How do you search and highlight a specific word within a cell?

Originally Posted by MarvinP

Hi bachfantasia,

See if http://excelexperts.com/Excel-Tips-F...Text-In-A-Cell
explains it for you.

I'm sorry I wasn't clear.

The purpose behind what I am trying to do is so that I don't need to manually search for the word I want highlighted. The highlighting is so I can find the word within a large amount of data easily. I do not need the highlighting to be permanent. The task at hand involves very long paragraphs of product data that are within a single cell and it is often a task that takes up a lot of time if I need to search for just one word within the cell. What I need to do is what you do on a Word document that contains large amounts of data, CTRL-F. This function on Word actually highlights the word temporarily you are searching for, so you don't need to look for the word. On Excel I can't find a way yet to highlight a specific word within a specific cell, so that I don't have to search for that word manually.

Basically pretend that the whole book War and Peace is copy and pasted into a cell and I want to search for just the name "Drubetskoy" within this single cell. I need a way so that I can click in that cell and search for the name "Drubetskoy" and have this name highlighted within the cell. Then I want to be able to do another search for just the name "Andreyevich". I would then search for the name "Andreyevich" and "Drubetskoy" is no longer highlighted and now only "Andreyevich" is highlighted.

Does this help? Thank you.