removing text within a cell

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

This might be simple but I can't figure it out. I have a
cell that is grabbing information from somewhere. For
example:

the cell reads 4891-010-501 and I want another cell to
reference it but only to grab the last three numbers (501)

I need this function and will need it over and over again
for something we do.

The cell could read any number in the 10 digit sequence
with dashes in them but will always end in a 3 digit
number and we always want just the last 3 numbers to
display.

any help would be greatly appreciated and can be emailed
to me at (e-mail address removed)

Thank you,

Dennis
 
Back
Top