help with formula
 

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

help with formula
 

Try:

=Mid(A1,20,8)


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109660

help with formula
 

If all the numbers of fixed length; try

=MID(A1,20,8)

If this post helps click Yes
---------------
Jacob Skaria


"Soth" wrote:


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