shadowsong
New Member
- Joined
- Mar 15, 2006
- Messages
- 26
I have two columns of text cells with values such as A1="1+1" and B1="1+2". I want to calculate =B1-A1 and get 1 as a result. Can this be done without using VBA?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Evaluating text string as math
- Thread starter shadowsong
- Start date
Excel Facts
Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
István Hirsch
Well-known Member
- Joined
- May 16, 2013
- Messages
- 1,634
Give this formula a try. If there are more than 12 numbers in A1 and B1 (altogether), continue the pattern in curly brackets:
=SUM(1*TRIM(MID(SUBSTITUTE("+-"&SUBSTITUTE(A1,"+","+-")&"+"&B1&REPT("+0",30),"+",REPT(" ",99)),{1,2,3,4,5,6,7,8,9,10,11,12}*99,99)))
=SUM(1*TRIM(MID(SUBSTITUTE("+-"&SUBSTITUTE(A1,"+","+-")&"+"&B1&REPT("+0",30),"+",REPT(" ",99)),{1,2,3,4,5,6,7,8,9,10,11,12}*99,99)))
Upvote
0
