Excel: Evaluating text string as math

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?

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of March 19, 2014.

For more resources for Microsoft Excel