The 'first' 5 numbers can be interpreted in two ways:

123456
=LEFT(C1,5) --- "12345" (this is a text)
=--LEFT(C1,5) ---12345 (this is a number)

654321
=RIGHT(C1,5) --- "54321" (this is a text)
=--RIGHT(C1,5) ---54321 (this is a number)

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=380387