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