Look at Replace Method in VBA help, there is an example.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"confused dot com" wrote in message
...
Sorry I meant to say I need a macro. I can record this operation but it
doesn't specify what sheet.

"Pete_UK" wrote in message
oups.com...
Highlight the data range beforehand - eg click the column identifier to
highlight a complete column. Then CTRL-H (or click Edit | Replace) and
a panel pops up to allow you to specify what to Find and what to
Replace it with. Buttons allow you to just Find, or Find next, or
Replace All etc.

Hope this helps.

Pete

confused dot com wrote:
Here's an easy one for you clever people, how do I find and replace on
a
single sheet or column? please.
D R