Delete all cells except containing specific text

[myawan]

Hi,
I have a large excel file with thousands of columns.
I want to keep all column headers plus only those cells which contain specific text '2G'. Rest of the cells should be deleted so that I am only left with column header and required cells below.
Sample photos of 'Before' and 'After' scenario is attached.
'Before' scenario which shows the raw data where I have to keep only those cells having the text '2G'.
'After' scenario shows required data after cleaning done.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Delete all cells except containing specific text
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[myawan]

This query is only posted at below link, nowhere else:

Delete all cells except containing specific text

Hi, I have a large excel file with thousands of columns. I want to keep all column headers plus only those cells which contain specific word. Rest of the cells should be deleted so that I am only left with column header and required cells below. Need your help guys.

www.excelforum.com