removing text within a cell

[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

 

[Thomas]

=right(A1,3)

A1 being your data cell

 

[dennis byrne]

thank you!!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!