Someone gave me a worksheet with a number of cells that have hard-coded numbers in them, eg. 5445.33+224.77-44+65. Lots of numbers. Now, I need to parse them out (with their proper sign) so that I can show the detail. Since there are multiple numbers, I am thinking about some kind of miracle macro that will put the string into a variable, and then maybe do/while len(var)>0, find the next "+224.77" , strip it out of the variable, write it to a new cell as a value, then save the now-shorter string back to the variable again, and start the process anew.
Does this make sense? Can someone suggest a basic set of code to do this. I'll bet there are plenty of users that might find it useful.