Limit Find/Replace to One Colum

[MikeKohler]

Hi, is it possible to limit Find/Replace to 1 column in Excel? I have a column for color with W and G for white and grey, but I also have a column for geographic location which contains West. Can I change the colour column without changing the location column?
Thank you,
Michael Kohler

 

[AnotherHiggins]

Select the column (click on the column's letter heading), then do the Find and Replace.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[TommyP]

Just click on the Grey Cell that shows the columns letter. This highlights the entire column and limits the find and replace option to just this column.

 

[MikeKohler]

Thank you, that saved me a lot of time.