clearing data in a cloumn

[censura]

Hi hope someone can help i have a spreadsheet where by putting an s in a cell in column D a list of sites i wish to visit can be sent to a word document
(thank you Leith Ross) what i would like to do is run a simple macro to clear all the s in the column to ensure no s's are left when a new search is done.

thank you

[davesexcel]

here's 3 different ways

Please Login or Register  to view this content.

[censura]

thank you for your help it works well