How can I seperate

[mdb231]

Hi All
can anyone tell me how I can seperate this from a dowmload copy and paste
Yor 6Gd C2Hc 32K
I have a column C which has this info in it how do I get it to seperate as just
2 in column K
32 in column L

so all i get from them are the numbers, the numbers in column K would go from 1 to 7
and column L could be any number.

Thanks

 

[jasonb75]

If the data format is consistant with your example, try

=--mid(c2,10,1)
=--mid(c2,14,2)

 

[mdb231]

Hi jasonb
Thanks for that it works great but, if there is one or three or more numbers in the part=--mid(c2,14,2) it shows error any way round this

123
1
1234

thanks for the rest of it though

 

[jasonb75]

Try

=--MID(C2,14,LEN(C2)-14)

 

[mdb231]

Hi Jasonb
works great just what the doctor ordered,
many thanks