Scanning only a seleted amount of numbers from a tracking number into excel

[gingrbaybee]

We have to scan incoming mail at work in column B on a 2010 excel spreadsheet. When I scan a fed-ex label, it adds 22 numbers in front of the 12 tracking number digits I need (total of 24 digits). I know I can add a column and do the =RIGHT(B9,12) to get the last 12 digits I need, but I am wanting to know if I can just scan the package to excel and have excel take out the extra digits in front for me without adding a column. Is this possible?

 

[rpaulson]

Put this code on the sheet.
Let me know how it works

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("B:B")) Is Nothing Then Exit Sub
    Application.EnableEvents = False 'to prevent endless loop

    If Len(ActiveCell) > 12 Then ActiveCell = Right(ActiveCell, 12)
    
    Application.EnableEvents = True
    

End Sub

hth,

Ross