ExcelBanter - Delete rows with Symbols

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete rows with Symbols (https://www.excelbanter.com/excel-discussion-misc-queries/265236-delete-rows-symbols.html)

shairal

Delete rows with Symbols

I receive files from China that always has foreign characters, which
sometimes translate to symbols or ASCII characters in it. I would like to be
able to delete any row that contains any of these ASCII/symbols in it. Help
please! Thanks!!

All times are GMT +1. The time now is 02:16 PM.