text formatting

[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

 

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