Need help for a specific find & replace

S

skuba

Hi Everybody!

I need to fill the spaces on some words with %20.
Eg.
D_010 SETMP2 KIT.jpg - before
D_010%20SETMP2%20KIT.jpg - after

I need to a replace in a whole column like that.

How can I do that?

And if possible, is there a way to make a macro for that or some way t
make it like a 1 click procedure?

Thanks a lo
 
T

Trevor Shuttleworth

Do an Edit | Replace... | Find what: " " (space, no quotes) and Replace
with: "%20" (again, no quotes) | Replace All

Regards

Trevor
 
A

AlfD

Hi!

And if need to do it again and again, try recording a macro. Just d
what you just did, but with tools>macro>record new macro noting ever
step.

Al
 
Top