vk7
Member
In the attached Excel sheet Data.xlsx, I have three rows including the column headers. However, upon closer inspection, I noticed that although the data in Row 2 and Row 3 appears identical, there are subtle differences due to extra spaces in the "Name" and "Country" columns of Row 2.
I'm seeking advice on how to use Excel features to highlight columns that may contain extra whitespace, making it easier to identify and resolve these discrepancies in the data.
I'm seeking advice on how to use Excel features to highlight columns that may contain extra whitespace, making it easier to identify and resolve these discrepancies in the data.