FIND & REPLACE ISSUE
Not with find and replace.. but with a helper column...
So, if your column is in A, then in B, format as text, then type =A2&"000"
and paste down.
"William" wrote:
I have a colomn with 2-digits (currently text format):
03
04
10
20
. . . etc.
I'd like to do a find and replace which adds three zeroes to the end, so
that I get this:
03000
04000
10000
20000
Is it possible?
Thanks
--
William
|