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.