Values to the Left and Right of Characters

[joes2580]

Is there a formula I can use that will help this problem?


For example I have parts and descriptions separated by a "/"

but;

Within the part description there are other "/" and part of the desc. Like the size.. 1/4 in.

11SMPPAZ0110050 / #4 X 1/2 PAN HD PHIL SMS ZINC

is an example.

What I want to tell excel is anything to the Left of the "/" I want in the cell to the left and anything on the description side, I want in another cell.



so Cell A1 would be "11SMPPAZ0110050"

Cell B1 would be "#4 X 1/2 PAN HD PHIL SMS ZINC"


Thanks.

 

[bbott]

Assuming your data is in C1:

In A1:

=LEFT(C1,FIND("/",C1)-2)

In B1:

=MID(C1,FIND("/",C1)+2,LEN(C1))