Split Two Numbers Separated by Backslash Into Two Cells

[tkoin12]

Hello All,

I have a spreadsheet that has two numbers separated by a backslash in one cell, like below:

[TABLE="width: 50"]
<TBODY>[TR]
[TD="class: xl67, width: 67, bgcolor: silver"]F/P KR EVERYDAY TOWELS 6P (72)276SFT SC 015836
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]3 / 3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]1 / 1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]3 / 3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]1 / 1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]1 / 1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]2 / 2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]3 / 3
[/TD]
[/TR]
</TBODY>[/TABLE]


What I want to be able to to is separate the two numbers into a different cells like below:
[TABLE="width: 100"]
<TBODY>[TR]
[TD="class: xl67, width: 67, bgcolor: silver"]F/P KR EVERYDAY TOWELS 6P (72)276SFT SC 015836
[/TD]
[TD="class: xl67, width: 67, bgcolor: silver"]F/P KR EVERYDAY TOWELS 6P (72)276SFT SC 015836
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]3
[/TD]
[TD="class: xl66, width: 67, bgcolor: transparent"]3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]1
[/TD]
[TD="class: xl66, width: 67, bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]3
[/TD]
[TD="class: xl66, width: 67, bgcolor: transparent"]3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]1
[/TD]
[TD="class: xl66, width: 67, bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]1
[/TD]
[TD="class: xl66, width: 67, bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]2
[/TD]
[TD="class: xl66, width: 67, bgcolor: transparent"]2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 67, bgcolor: transparent"]3
[/TD]
[TD="class: xl66, width: 67, bgcolor: transparent"]3
[/TD]
[/TR]
</TBODY>[/TABLE]


Because I have about 50 columns, I don't want to use Text to Columns. Is there a formula or macro I could use? It doesn't have to be as clean like I layed it out (in regards to the column title) but I just to really separate the two numbers into two cells.

Thanks in advance!

Joel

 

[nancymk]

in first column =left(a2,find(" ",a2)-1)
in second column =RIGHT(A2,LEN(A2)-FIND(" ",A2,FIND("/",A2)))