| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find & Replace problems... at the end of my thread (ha)
Hey guys. I have Excel 2007. I have a spreadsheet with email addresses in it surrounded by other text. I want to automatically highlight in yellow each row containing the words gmail, yahoo, hotmail and so on.
I CTRL-H then enter the info as you see it in the pic attached. When I click Replace All it says "that function is not valid". It works like a charm for every other word I test it with. It's almost interesting in a head-exploding kind of way. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| more character 160 leading/trailing find/replace problems | Excel Discussion (Misc queries) | |||
| Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
| Problems with find/replace function | Excel Worksheet Functions | |||
| Problems with number formats when using Find/Replace | Excel Discussion (Misc queries) | |||
| Problems with Find & Replace | Excel Discussion (Misc queries) | |||
Threaded Mode
