Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have several columns with several cells. Some of them contain the letter "R". I want to change all cells across all columns that contain the word "R" to be replaced with a blank. Normally I would just do a REPLACE all for the letter "R" with a blank, but this will mess up other columns that might have a word like "Road" in it. So, how do I replace all R's, but ONLY if the cell ONLY contains R?

share|improve this question

2 Answers 2

up vote 1 down vote accepted

ok. here is what you do.

  • select all the cells on your sheet
  • then hit ctrl+F
  • select the 'replace' tab
  • click on options
  • check 'match case'
  • check 'match entire cell contents'
  • in 'find what'- R
  • in 'replace with'- whatever you want
  • click 'replace all'
share|improve this answer

In "Find and Replace", expand the "Options" section and check the "Match entire cell contents" option.

Then when you perform your replace, words containing 'R' won't be affected. You should also check the "Match Case" option if you want to match 'R' but not 'r'.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.