Dear Sir,

I wish to extract the last 6 characters if a cell in column A has 13
characters, otherwise only extract the last 3 characters.

Illustration:

A B
1 510104BGH9006 BGH9006
2 510104TRL TRL
3 510104OTH9016 OTH9016
4 510202HLG HLG
5 510104KJY9018 KJY9018
6 510203FTP FTP
7 510104IPL9023 IPL9023
8 510209SGS SGS

May I know what formula must input at cell B1 and copy downwards to get the
answer ?

Thanks

Low



--
A36B58K641