Quote:
Originally Posted by BobBridges
Just to clarify, it sounds like you're saying that A1 contains not a number but a character string "0.1, 1.5, '0.5, '1.2". Is that right?
If so, you can get Excel to split the character string up into individual numbers and then add the numbers together. But the SUM function, if you use it at all, won't come in until the very end. First you have to explain to Excel how to break up the string into pieces. Do you want to continue?
|
Could you elaborate on this for me please? The reason I ask is although the solution provided by BobBridges works the application I am trying to use it with doesn't support xlsxm files only xls or xlsx so I was wondering if your solution supports this?
Thanks
05-12-2014, 04:45 AM
Similar Threads
Summing up values in a Single Merge Field
Windows 7 64bit 
Office 2007
Threaded Mode