Split text based on specified string in Excel 2010

January 7, 2013 at 02:20:18
Specs: Windows 7

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.


See More: Split text based on specified string in Excel 2010

Report •


#1
January 7, 2013 at 02:22:13

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

Report •
Related Solutions


Ask Question