| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
spit & sum comma delimted value
Try this one
U have data in A1 in B1 put this formula =REPLACE(",", 1,1,"+")&SUBSTITUTE(A3,",","+") and then copy | go to Edit | paste special | values | ok | On Sep 8, 3:16*am, Francois Taljaard <Francois wrote: Hi Need to split cell values and sum. Cell A1: 0,20,300,20,300 * Cell A2: 280,34,200,129,0 Result for A1 = 640 Result for A2 = 643 Note that the length of cell and values are not consistent. Any help much appreciate. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CANNOT Import comma delimted, quote qualifed text file into Excel. | Excel Discussion (Misc queries) | |||
| how do I open a comma delimted file so that all the fields are se | Excel Discussion (Misc queries) | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) | |||
Threaded Mode
