put this in the next column and copy down.
=RIGHT(I2,LEN(I2)-FIND("_",I2))
Or, if you want to eliminate the numbers to the left of _ and have them in
the cell they were originally you will need a macro.
Please advise

--
Don Guillett
SalesAid Software

"anorton" wrote in message
...
Hi all,

I would like to see if there is a way to modify the numbers in a cell to
only show a partial? For example:

8709300242_4576
8710010110_4550
8710010157_4580
8710050132_4564

I want to only show:

4576
4550
4580
4564

Thanks.