Results 1 to 2 of 2

Thread: Find & Replace problems... at the end of my thread (ha)

  1. #1

    Angry Find & Replace problems... at the end of my thread (ha)



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Untitled-1.jpg 
Views:	23 
Size:	21.2 KB 
ID:	1372  

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Can you upload a sample spreadsheet that exhibits this behavior?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •