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?
=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.