I am having trouble removing invisible characters. I have tried using the clean/trim function + the REPLACE function but the characters are still there. When I check the length of a row, it is either blank OR 0. This is throwing off my model bc the 0 will not be recognized when I count the number of blank rows.
Any ideas on how I can remove this? Below is a screenshot and link to sample data.