+ Reply to Thread
Results 1 to 4 of 4

Email Pattern

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    460

    Email Pattern

    Hi All,

    We have framed the email pattern for the first name and last name. We need the formula to identify which of these pattern we had framed. Which is in H Column highlighted in blue color. I have attached the same file.

    Thank Youu
    Attached Files Attached Files
    Last edited by sathishkm; 06-23-2022 at 02:07 PM.

  2. #2
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    460

    Re: Email Pattern

    Hi All,

    We have framed the email pattern for the first name and last name. We need the formula to identify which of these pattern we had framed. Which is in H Column highlighted in blue color. I have attached the same file.

    Thank Youu

  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,929

    Re: Email Pattern

    I am starting to look at this but be aware that some possibilities don't resolve, such as

    Values as displayed
    1
    Fred
    Franklin
    @abcxyz.com
    ff@abcxyz.com
    ff
    ?????
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,929

    Re: Email Pattern

    See attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Rotation Pattern based on the Pattern String for scheduling tasks
    By qadeerume in forum Excel General
    Replies: 8
    Last Post: 08-11-2020, 11:49 PM
  2. Replies: 4
    Last Post: 01-27-2020, 04:40 AM
  3. Replies: 7
    Last Post: 08-27-2019, 08:37 AM
  4. Continuing a pattern on autofil without pattern re-starting
    By jakeyoung111 in forum Excel General
    Replies: 4
    Last Post: 06-22-2016, 11:11 AM
  5. [SOLVED] Lookup and return rows based on pattern start and pattern end
    By JDI in forum Excel General
    Replies: 18
    Last Post: 11-16-2014, 11:44 PM
  6. Copy down hypertext cell range pattern & cell reference formula pattern
    By Underexcelling in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-10-2014, 03:23 AM
  7. Replies: 2
    Last Post: 02-16-2009, 08:32 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1