Not entirely true, clean does not remove trailing html char 160 which seems
to be fairly common when data is copied from a web site


--


Regards,


Peo Sjoblom


"Sasa Stankovic" wrote in message
...
Hi,
You can use function TRIM or/and CLEAN.
TRIM removes extra spaces around text (all spaces before and after text
and leaves only one space between words. CLEAN removes any nonprinting
characters.
So, you'll get some extra columns but your imported data will be filtered.