Excel Multiple Keyword Extraction from cell

Status
Not open for further replies.

KK3008

New Member
Joined
May 8, 2019
Messages
8
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 NameExample New Column
2016_00_InboundWeb_Request_A_Demo

InboundWeb
2016_04_PPC_Google_Generic


PPC_Google
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,102,363
Messages
5,486,406
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top