So i have an Excel document where I have cells with data 4+6 5+3 3+5 etc. how can I add them up in such a format? So for example if i have 5+2 if will be 7 in a different cell. It is a preexisting document so I can't simply split the data into more cells and add them up with a basic SUM()
Asked
Active
Viewed 94 times
0
-
1Have a look at this thread: http://stackoverflow.com/questions/4471884/how-to-turn-a-string-formula-into-a-real-formula – mechanical_meat Feb 16 '17 at 16:58
1 Answers
1
With data in E3, in E4 enter:
=--MID(E3,1,FIND("+",E3,1)-1)+MID(E3,FIND("+",E3),9999)
this should be for for any data like 1234+8765
Gary's Student
- 95,722
- 10
- 59
- 99
-
I see what you did but i don't understand the -- part. Also in my excel the formatting was a bit different (i have to use a semicolon not a comma) =MID(E3;1;FIND("+";E3;1)-1)+MID(E3;FIND("+";E3);9999) – Smornik Wafflehouse Feb 16 '17 at 17:36
-
@SmornikWafflehouse The ***++*** insures text is converted to number. – Gary's Student Feb 16 '17 at 17:38