Are they always in the same format Adam? ie 3 letters, 3 numbers. If
they are try a combination of the LEFT and LEN functions.

ie *=LEN(LEFT(A1))* etc.

If the pattern is irregular, yes you can do it, but you would need to
write a small macro. To help you, we would also need more precise
rules. ie What would you want to extract if the cell contained
A23BGF44?

Martin


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=375769