help with formula

S

Soth

Hi-

I have this long string of number 1001.020.0000.0055.24110100.00000.0000 in
a cell and I just need to separage only this 8 digit number 24110100 and I
don't care the rest of the numbers. Is there a better way to do so? Perhaps
formulas?

Thanks
Soth
 
J

Jacob Skaria

If all the numbers of fixed length; try

=MID(A1,20,8)

If this post helps click Yes
 
Top