Thread: [Solved] Sum values within a single cell
View Single Post
 
Old 05-12-2014, 04:45 AM
shabbaranks shabbaranks is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Mar 2011
Posts: 89
shabbaranks is on a distinguished road
Default
Quote:
Originally Posted by BobBridges View Post
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
Reply With Quote