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?
3 Replies
=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.
Thanks. Using Microsoft 365 so I'll give Filter a go.
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.
