Results 1 to 2 of 2

Thread: Excel Multiple Keyword Extraction from cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Excel Multiple Keyword Extraction from cell

    I am trying to create a Formula(s) that will extract the campaign name that generated the lead in the sheet.

    Campaign Name
    2016_00_InboundWeb_Request_A_Demo
    2016_04_PPC_Google_Generic
    2016_09_Hotleads_EngagementPrograms
    2016_12_Telemarketing_Infocore_Medical
    2016_04_PPC_Google_Generic

    The output needs to be like-

    Campaign Name Example New Column
    2016_00_InboundWeb_Request_A_Demo
    InboundWeb
    2016_04_PPC_Google_Generic

    PPC_Google
    0 0
     

  2. #2
    Moderator Macropod's Avatar
    Join Date
    Aug 2007
    Location
    Canberra, Australia
    Posts
    3,257
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Excel Multiple Keyword Extraction from cell

    Duplicate of: https://www.mrexcel.com/forum/excel-...ords-cell.html
    Kindly read Mr Excel's policy in Rule 12 against asking questions about the same topic in multiple threads: http://www.mrexcel.com/forum/board-a...rum-rules.html
    Thread closed. You may continue the discussion in your other thread.
    Cheers
    Paul Edstein
    [MS MVP - Word]
    0 0
     

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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