I have a spreadsheet with @ 4000 cells containing a summation like (for example) =439+23+678+1. [Stock market data.] Each number in the formula could vary between 1 and 5 digits. I need to replace each cell with a summation of only the first two numbers. A Find and Replace operation would be perfect, but wildcard characters don't work for numbers. I know there is probably some complicated VBA instruction that would work, but I'm VBA illiterate, so if anyone can help on that front, please don't assume any prior knowledge. Thanks in advance for any assistance!!
When you say wildcards don't work for numbers, what do you mean? Do you have Use Wildcards selected? Does each cell have the same number of fields? If so, you should be able to search for this:
If not, and there are no decimals, you could search for this:
In both cases, replace with
You might have to switch to Formula View first using Ctrl` (backtick) if you haven't already.