text formatting

S

sagiraju

i have text data like this
1-58/a
i want to convert thease colum like
1
58
and also extract number from this data also
please help me its very important to m
 
J

JE McGimpsey

One way:

B1: =LEFT(INDEX(A:A,(ROW()+1)/2),FIND("-",INDEX(A:A,(ROW()+1)/2))-1)
B2: =MID(LEFT(INDEX(A:A,ROW()/2),FIND("/", INDEX(A:A,ROW()/2))-1),
FIND("-",INDEX(A:A,ROW()/2))+1,255)

Not sure what you mean by "extract number from this data also".
 
Top