Reading the last for characters of a data.

[DamienPham]

Hello. I have a list of values in a data that has 16 characters o
numbers and letters (ie. 01V4245608099269). The only numbers/letters
need are the last 6 of the list. How would I create a formula that read
only the last 6

 

[Spencer101]

Hello. I have a list of values in a data that has 16 characters o
numbers and letters (ie. 01V4245608099269). The only numbers/letters
need are the last 6 of the list. How would I create a formula that read
only the last 6?

=RIGHT(cell,6)

Change cell for the relevant cell reference. For example =RIGHT(A1,6

 

[Spencer101]

205, 209, 235, 236, 237, 238, 239, BH1, BV6, ANR, ANP, FW3, BK1, BK

As luck would have it, whilst trawling through several other forums fo
the answer to this, someone asked almost exactly the same question

So I took that formula and adapted it slightly to fit your needs

With this version you don't even need the column B that extracts jus
the last six digits, it merely searches the last six digits of eac
entry in column A directly

Hopefully you can adapt it to meet the requirements of your specifi
workbook, although I'm happy to assist you with that too if need be

Please don't ask me to explain exactly how it works as I'm still tryin
to fathom that myself :

+-------------------------------------------------------------------
|Filename: DamienPham Example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=581
+-------------------------------------------------------------------