Another option, if your numbers are inconsitently formatted where some
have 1 letter in the 6th position, 2 letters in 6th & 7th or no letters
then try,

=CHOOSE(LEN(A1)-6,A1,SUBSTITUTE(A1,MID(A1,6,1),""),SUBSTITUTE(A1,M ID(A1,6,2),""))

This only works if the smallest number of characters you'll have is 7.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=513674