Getting Google Spreadsheets to interpret string as formula
March 12, 2009 10:53 AM Subscribe
I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52
. I can easily substitute " " for "+" and concatenate a "=" in front
. Now I have a text string which looks like a formula but isn't one.
How can I make Google Spreadsheets interpret this string as a formula?
These Excel solution
posted by Akeem to computers & internet (3 answers total)
don't apply because I'm not always around when someone makes a new form entry.
it's possible to interpret a string like 4+9+17+22
and get a correct result.
does not work for 17*3
("Wrong number of arguments
", even though split should create 2 arguments here). So a combination of splits, multiply and sum also fail.
Is there another solution?