|
|
#6
05-22-2017, 03:12 AM
|
||||
|
||||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Sorting numbers within cell
|
michaelst | Excel | 9 | 04-22-2017 10:51 PM |
| Difference between 2 numbers in same cell | Neila1982 | Excel | 1 | 02-12-2017 01:40 AM |
|
Add Numbers from One or Another Cell
|
Kilch | Excel | 3 | 01-31-2017 12:55 PM |
| Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
|
adding numbers in same cell
|
jetdude68 | Word Tables | 1 | 07-20-2010 12:30 AM |
Windows 10 
Office 2013
Threaded Mode