View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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