View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Dennis is offline
external usenet poster
 
Posts: 1
Default removing text within a cell

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

Thank you,

Dennis