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.
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.