Find & replace question.....I believe
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
|