MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Last 4 digits of cell

Posted by John on January 03, 2002 2:44 PM

I would like to take the data from a bar code scanner and delete all but the last 4 digits. So for instance the user would click in cell A1 and scan the bar code which is "123456789". The A1 cell would contain the data "6789". What is the best way to do this?

Posted by Scott on January 03, 2002 2:58 PM

=RIGHT(A1,4) (NT)