I am learning excel from scratch, and I have a dataset of around 7000 entries. Some of these entries have texts such as data for cleaning. This obviously is not clean data, and I wish to highlight it. I tried using conditional formatting, but failed. I tried get rid of the special characters altogether, but have been failing to do so as well. Some solutions on the internet suggest using developer mode and writing up a VBA code myself. Is that the only solution? If there is another simpler way to highlight/clean my data, please help.
Conditional formatting – hihglight cells containging text
Find and Replace
Find only
ms08 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.