MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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
dismal.

=COUNTIF(C2:W2,"SUCCESS")/COUNTA(C2:W2)*100

The best I can do is to save it as

"=COUNTIF(C2:W2,"SUCCESS")/COUNTA(C2:W2)*100"

which then imports as ...

=COUNTIF(C2:W2,SUCCESS")/COUNTA(C2:W2)*100"

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 ??


Posted by Mark W. on October 05, 2001 5:36 AM

The problem isn't with the programmer...

Use "=COUNTIF(C2:W2,""SUCCESS"")/COUNTA(C2:W2)*100"

Posted by Jason Davis on October 05, 2001 5:57 AM

Mark,
I dont know what the rest of the file looks like
but have you tried to assign the break point your self when you import? or assign the break character?

Or just use tab delimited....... might try it out