Excel 2007 - Find a word

Question

I have like 3000 works in an excel cell that I need to search one word in. It does not highlight the word, it only places me into the cell with the word.

Anybody has any idea how I can get the word highlighted that I am looking for?

Thank you,

Steve

Answer 1

alt-e-f (find), type the word, then you can go thru the cells with em

Answer 2

You have to change the font/highlighting/background of the characters you find using the Characters property in VBA. This can be packaged with the actual search or you can perform the search manually and the highlighting with a macro. See this link for code samples http://www.ozgrid.com/forum/showthread.php?t=66197

Note that since you are actually changing font in Excel you will need to revert it to normal if you don't want the highlight saved with the document.

Answer 3

If it's just one long cell, or if all the long cells are in a column, you could try using the "Text to Columns" feature (under the Data tab of the Ribbon). If you set it to be delimited by space (assuming your words are separated by spaces), this will make it so that each word occupies its own cell. Then when you use Find, it will highlight the exact cell.

Another option would be to copy the range you want to search and paste into MS Word. From there, you can search, and it will highlight the exact word.

Answer 4

If you save the whole book as an HTML. Then open it in your preferred browser, you can search in the normal way and it should highlight the desired word.

Answer 5

export as a .csv then, then import so that it breaks each column on the space, then you can do what i said above, and then combine the cells. why don't you just copy paste the contents of the cell into notepad and do a seach & replace there?

Answer 6

You can use conditional formatting to highlight the entire cell that contains the search criteria, but I think you want only the specific text to be identified?

I haven't tried this, but here is a discussion on this:

http://www.mrexcel.com/forum/showthread.php?t=397445