Try:

=RIGHT(A1,LEN(A1)-FIND("_",A1))

If you mean to alter the actual contents of the original cells then you
would need to do it with VBA

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"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.