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

**bachfantasia** · 01-16-2014, 06:51 PM

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

Is there a way to search within a cell that contains a large amount of data and only highlight a specific word? I know you can use the conditional formatting function to highlight a whole cell that contains a certain word, but I don't need the whole cell highlighted.

I just need a specific word highlighted when I search for it within a specific cell, like when you are using Word, or if you are using the CTRL-F function on a website and you can search for a word and the screen will just highlight the specific word you are searching for.

Is this possible? If so can you please provide a step by step solution for this?

Thanks.

**MarvinP** · 01-16-2014, 06:59 PM

Hi bachfantasia,

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

**bachfantasia** · 01-16-2014, 07:25 PM

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.