I have a lot of these strings in each cell:

CHEQUE DEPOSITADO NESTA I.CREDITO N. 4378319839

The are not always equal, the number of charecters can change a lot.
How do i use the MID function to allways extract to another column the
8 last figures less the two last ones.
In this case, the number be extracted should be 783198. Please note
that, as i said, the strings size can vary, but the figures allways
come in the end.

Thanks a lot


--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=564310