Forum Discussion
Alarm for invisible characters?
I recently copied a list of names from a webpage to Excel and started comparing them to another list, but got no matches. Turns out the imported list had a string of nonbreaking spaces in front of ea...
Einarry Copying from web pages is often the cause for getting "dirty" data as you describe. A good idea would be to use CLEAN and TRIM after you pasted the data into Excel.