Another nice option.

Ron Coderre wrote:

Dave

If *_ is replaced wth an apostrophe, any leading zeros after the underscore
will be preserved. (although, the remaining characters will be text...if
that's OK with the OP)

8710050132_0064 would become 0064

***********
Best Regards,
Ron

XL2002, WinXP

"Dave Peterson" wrote:

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


--

Dave Peterson