Excel 2007 : Extract last four digits from alphanumberical string

**questionguy** · 07-16-2012, 11:43 AM

Hi all,

I have the following serial numbers in column A:

03K46L897
03K41L890 A
03J86L888
03P80L886 B
03K42L891
03B65L895 A
03B65L895
etc...

Is it possible to extract the last four DIGITS into Column B??
I tried LEN, MID, RIGHT, LEFT, etc, but had no success...

**NBVC** · 07-16-2012, 11:47 AM

Do you mean you want the L897 codes?

=RIGHT(TRIM(LEFT(A1,FIND(" ",A1&" "))),4)

or last 4 digits, without the "L".

=REPLACE(RIGHT(TRIM(LEFT(A1,FIND(" ",A1&" "))),5),2,1,"")

**questionguy** · 07-16-2012, 11:55 AM

Thank you NBVC, that was quick...

basically i want the formula to extract the last digits after the L (or whatever Alphabetical Value). Sometimes there are 3 digits, sometimes 4, less or more. Is that possible?
03K49L897
03K41L890 A
03J76L888
03P80L886 B
03K12L891
03B65L895 A
03B65L895
12GQ19012QGR1905
12GH11069QGR1900
12RP12001QGR1916
12RP12002QGR1961
12MH11008QGR1894
12GG11092QGR1910 A
12YY11092QTR1910 B

**NBVC** · 07-16-2012, 12:14 PM

Try:

Please Login or Register  to view this content.

**questionguy** · 07-16-2012, 12:15 PM

Many Thanks!!!!!!!! It works...

**Cutter** · 07-16-2012, 12:51 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save