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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Cell format 6
Paragraph numbering in Word 1
Need some PWA help 0
Help 2
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Setting column width in a table with a macro is not working 0
Cumulative formula for word table 0

Top