|
|
#1
05-09-2014, 05:26 AM
|
|||
|
|||
Sum values within a single cell
Hi,
Is it possible to sum values within one cell of Excel. I appreciate its probably not good practice BUT its an export from a 3rd party application and rather having to juggle the data a sum from that single cell would be ideal? Example: A1 - 0.1, 1.5, '0.5, '1.2 B2 - Sum of A1 (excluding the ' and ,) Cheers 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Summing up values in a Single Merge Field
|
Beowolf | Mail Merge | 1 | 03-07-2014 03:26 PM |
| Finding Earned Values for Different Baselines in a single project | pratik6312 | Project | 1 | 08-22-2013 11:18 AM |
|
How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
|
Sum & difference between multiple values in a single cell
|
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
|
How can I write the following (whole) formula in a single cell?
|
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
Windows 7 64bit 
Office 2007
Threaded Mode