Importing formulas in CSV format to Excel
Posted by Mark on October 05, 2001 4:40 AM
I'd like to pull in the following formula into excel
However, I can find no way of persuading Excel to parse
this line correctly. The import of formulas seems pretty
The best I can do is to save it as
which then imports as ...
Which is wrong!. The parsing routine is closing off
the CSV parameter at the first comma instead of ",
If the programmer had done this then I guess it would
at least import the formula intact.
Help!! - Any ideas ??