Thread: Add only first numbers in each cell
View Single Post
 
Old 05-22-2017, 03:12 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2013
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,159
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
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
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote