Forum Discussion
Remove text entries from column
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?
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.