i need to sort by 4th char. or split the data into two different colm.
D Dave F Oct 20, 2006 #2 =LEFT(A1,3) assuming your data is in A1. =RIGHT(A1,3) assuming your data is in A1.
A Anna Oct 20, 2006 #3 thank you so much, i just figured it out. Dave F said: =LEFT(A1,3) assuming your data is in A1. =RIGHT(A1,3) assuming your data is in A1. Click to expand...
thank you so much, i just figured it out. Dave F said: =LEFT(A1,3) assuming your data is in A1. =RIGHT(A1,3) assuming your data is in A1. Click to expand...