I have one column created with 5 or 6 digits in the cells with a plus sign two from the last digit (ex. 000+00; 0000+00). I need to create two other columns, one with what's on the left side of the plus sign, and one with what's on it's right side. I wouldn't mind doing it by hand, but there's 103,711 entries... anyone have any ideas?!
migrated from stackoverflow.com Oct 19 '11 at 16:47This question came from our site for professional and enthusiast programmers. 


Assumptions mentioned in the OP:
If A1 is the cell with the full text, in the cells for left side:
In those for the right side:
Here's a good function reference: http://office.microsoft.com/enus/excelhelp/excelfunctionsbycategoryHP005204211.aspx 


Here's another solution. These formulas obtain the position of the "+" in each string and then use that number to obtain the left and right substrings (regardless of their length). Left Side:
Right Side:
Or if each of the entries only have 2 characters to the right of the "+", Jonathan's formula would be better: 

