I have a column having text in A+B (e.g. 10+20) format. I have to do calculations based on A and different set of calculations based on B. how to separate the above string as 10 and 20 so that I can read 10 and 20 separately.

Oops...found the right left function with combination of Find. Got the formula =LEFT(<cell#>, FIND("<string to search>", <cell#>)-1)

Ask Your Question

Weekly Poll