Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2009
    Posts
    34
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Fuzzy id a name within an email address

    Hello,

    In an excel spreadsheet I have a column of surnames and a column of their email addresses, I want to identify the email addresses that donít contain the surname within them, is this possible?

    Many thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    If the surname is in A2 and the email address in B2 this will give True/False for the surname being in the email:
    =ISNUMBER(SEARCH(A2,B2))

    Steve

  3. #3
    Lounger
    Join Date
    Dec 2009
    Posts
    34
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by sdckapr View Post
    If the surname is in A2 and the email address in B2 this will give True/False for the surname being in the email:
    =ISNUMBER(SEARCH(A2,B2))

    Steve
    Steve,

    How good is that?

    Works like a dream, very many thanks

Posting Permissions

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