| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
