![]() |
#1
|
|||
|
|||
![]()
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 | Thread Starter | Forum | Replies | Last Post |
![]() |
paulkaye | Word | 4 | 12-06-2011 11:05 PM |
![]() |
slayda | Word | 3 | 09-14-2011 02:16 PM |
![]() |
kjxavier | Word | 6 | 08-19-2011 09:56 PM |
![]() |
shabbaranks | Excel | 4 | 03-19-2011 08:38 AM |
![]() |
MommyO | Word | 1 | 03-09-2011 05:47 PM |