Remove text entries from column

New Contributor

I have some data from a noise meter as CSV values down a column.

Some of the entries show 

"UNDER RANGE" instead of a value. 

How can I easily remove those entries prior to processing the data? 

3 Replies


Perhaps the simplest is to apply filter to that column, unselect "UNDER RANGE", copy filtered range and paste it into new location, better in new sheet.



You can try this formula. Then you can copy the data in range B1:B18 and paste only values. If you work with Excel 2019 or later you can apply the FILTER function.

text entries.JPG 


Thanks. Using Microsoft 365 so I'll give Filter a go.