Find and Replace in one column only

[Jon12345]

How do I do this?

Thanks,

Jon

 

[Mike Blackman]

Hi Jon,

Simply highlight the entire Column and then Ctrl & H to bring up the Find/Replace inputbox.

Or in VBA;

Columns("B:B").Replace "Test", "", xlPart

 

[Jon12345]

Thank you!