Quote:
Originally Posted by Guessed
I'm not a moderator here so I can't move it but I can answer it.
Rather than adapting Graham's code to work in Excel, I would first suggest you do it without a macro. It is easy enough to separate the two numbers into two columns and then do a normal sum formula on the first column.
Select Column A and go to Data > Text to Columns and choose Delimited > Next > tick Space > Finish
|
Thanks guessed, that's a solution, but I actually need to keep them in one column because of other things going on in the spreadsheet, so hopefully I can get a macro that works in Excel.