Delete row if containing a certain text Value

[BrownCJ1221]

Hi,

I'm looking at stock data over the past 20 years and some companies have missing data. This is showing as 'N/A'

Id like to delete the entire column if any cell contains an 'N/A'. I've tried to do this through the F5 function but this only selects the individual cell and not the entire column.

Is there any suggestions how I could complete this task more efficiently than looking through 500 columns and deleting them individually?

Thanks

 

[queuesmef]

First make your data a Table in Excel...so you can filter it. Select the column with the filter you would like to search for (Ex. 'N/A'). Then I would Highlight the ROWs along the left side (Click on the row number and drag down) ....then hit the delete key.

 

[BrownCJ1221]

First make your data a Table in Excel...so you can filter it. Select the column with the filter you would like to search for (Ex. 'N/A'). Then I would Highlight the ROWs along the left side (Click on the row number and drag down) ....then hit the delete key.

Thank you.
I used: Ctrl F to find the value
Find all
Ctrl A

Then clicked Delete
Then all columns.

Thanks for your help