Solved Add numbers in cell separated by semicolon

Microsoft Office excel 2003
August 16, 2011 at 08:53:53
Specs: Windows XP
Hi all, wondering if I could get some help, relatively new at using Excel (version is 2003). In one cell I have 12 numbers/text separated by semicolons (IE - ?;?;0;1558;0;0;0;?;?;?;?;?). Is there any way I can find the sum of all the numbers in a cell next to it (IE - A1=?;?;0;1558;0;0;0;?;?;?;?;?, A2=1558). I have multiple cells to apply this same formula too, all different numbers and "?" in different places for each cell, but always 12 numbers or ? separated by semicolons. Hope this is clear, thanks for help in advance.

See More: Add numbers in cell separated by semicolon

August 16, 2011 at 11:11:39
✔ Best Answer
Select the cells with the strings in them and click Data...Text-To-Columns.

Choose the Semicolon box...Finish

SUM the resulting range of 12 cells.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 16, 2011 at 11:36:04
Thanks much, worked.

Report •
Related Solutions

Ask Question