Forum Discussion

BillR30's avatar
BillR30
Copper Contributor
Feb 21, 2023

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? 
excel
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 21, 2023

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.

 

  • BillR30's avatar
    BillR30
    Copper Contributor
    Feb 22, 2023

    OliverScheurich 

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

Resources