Forum Discussion
Restricting Find/Replace to single column
Hi, I wish to run Find/Replace on a single column of a woeksheet. At the moment, Find/Repace replaces every occurance of the word I wish to replace on the entire workbook. I want it to only affect a ...
Thanks,
I found that it works for search, but not for "replace all".
I found that it works for search, but not for "replace all".
I think I just figured this out.
ctrl+H
select options>change search to by columns.
type in your "find" what and "replace with". click find all.
Then select the column you want to change.
