Remove text entries from column

[BillR30]

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? 

[#2]

@BillR30 

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.

[#3]

@BillR30 

=IF(ISNUMBER(A1),A1,"")

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.

 

[#4]

@OliverScheurich 

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