I have a large spreadsheet in which many of the cells contain formulas.
How can I produce a delimited-text version of this spreadsheet such that all formulas appear as the text of their source code?
For example, for a spreadsheet in which column
14 59 27
B1 is set to
=SUM(A:A), and all remaining cells are empty, if we did "Save As" CSV, the resulting
*.csv file would look like this (last two cells of second column are empty):
14,100 59, 27,
In contrast, what I want would look this:
14,=SUM(A:A) 59, 27,
In fact, the non-formula values are unimportant (except as placeholders), so the alternative below would be fine too. Here the only non-empty cells are those corresponding to the formula-containing cells in the original sheet; in this case, the leading '=' can can be omitted from the non-empty cells:
,SUM(A:A) , ,
PS. I'm VBA-illiterate, so I'd like to avoid it if at all possible.