This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is there a simple way to do a 'Find and Replace' in only one column? I have a large spreadsheet where I'd like to replace numbers with specific text however I would like to confine it to one particular column. Of course I can do it manually, but it is a recurring need so I'd prefer to find a way to automate it. A perfect solution would be a marco or VBA code that asked the column name, value to find & value to replace.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
If you select the column by clicking on its column heading, Find and Replace will operate within that column only.
Hi,
First select that complete column in which you need to perform replace .Don't use Find all option , instead of that use find next and after that use replace all. Then it will only replace in selected column.
Thanks,
Vinay Gupta
I can even begin to tell you how many times I have looked this up. I think the problem is the "within" dialog box pre-fills/defaults to "Sheet". Maybe it should default to "Selection" or just be blank.
When I see this I think, "but I dont want to replace all in this sheet, only in my selection!!"
... I don't think I'll forget after writing this response, but I'm not the only person who uses excel!
This issue was almost the death of me. Simple fix that makes not a lot of sense, but when you hit ctrl+F or ctrl+H, make sure your Within: drop down is selected to 'Sheet' not 'Workbook'. If Workbook is selected, it will override the selection you have made. This is the case, even if this box is not open and/or you are coding the Find and Replace.
If you select the column by clicking on its column heading, Find and Replace will operate within that column only.
Double click on the column heading.