Excel Multiple Keyword Extraction from cell

[KK3008]

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

[TABLE="width: 367"]
[TR]
[TD]Campaign Name[/TD]
[/TR]
[TR]
[TD]2016_00_InboundWeb_Request_A_Demo
[TABLE="width: 367"]
[TR]
[TD="width: 367"]2016_04_PPC_Google_Generic
[TABLE="width: 367"]
[TR]
[TD="width: 367"]2016_09_Hotleads_EngagementPrograms
[TABLE="width: 367"]
[TR]
[TD="width: 367"]2016_12_Telemarketing_Infocore_Medical
[TABLE="width: 367"]
[TR]
[TD="width: 367"]2016_04_PPC_Google_Generic

The output needs to be like-

[TABLE="width: 500"]
[TR]
[TD]Campaign Name[/TD]
[TD]Example New Column[/TD]
[/TR]
[TR]
[TD][TABLE="width: 339"]
[TR]
[TD]2016_00_InboundWeb_Request_A_Demo

[/TD]
[/TR]
[/TABLE]
[/TD]
[TD]InboundWeb[/TD]
[/TR]
[TR]
[TD]2016_04_PPC_Google_Generic[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]

[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]
[/TD]
[/TR]
[/TABLE]

[TABLE="width: 339"]
[TR]
[TD]PPC_Google[/TD]
[/TR]
[/TABLE]

 

[Macropod]

Duplicate of: https://www.mrexcel.com/forum/excel-questions/1097040-extracting-multiple-keywords-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-announcements/99490-forum-rules.html
Thread closed. You may continue the discussion in your other thread.