Select the range
edit|replace
what: *_
with: (leave blank)
replace all

However, this will change:
8709300242_0023
to just plain old 23
But you could give the cells a custom format of 0000.




anorton wrote:

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.

--

Dave Peterson