1

I have several cells in Excel 2007 that contain long sentences with the letter r between words. For example:

"The product code is r A23000"

I tried typing "r" in the Find box but the results show not only single "r" but any words / sentences containing "r" - e.g. I was trying to get this done.

How can I search for an isolated r, or is there any Excel add-in that could help, or any VBA code to list the results line-by-line, like the Find box does?

5

The simplest method would be to search for the letter r with a space before and after the character. e.g: " r "

Before

After

I replaced all instances of the letter r with a space to demonstrate.

  • You're welcome, and for future reference this should work with most programs. :D – Zain Patel May 24 '13 at 11:31
  • I'd suggest, another reason for avoiding tags in Titles. – pnuts May 24 '13 at 11:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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