TRIM() removes all multiple and trailing spaces

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kamran" wrote in message ...
| Hello,
| I have a spreadsheet full of entries imported from a database, chock-full of
| trailing spaces of different lengths. Is there any simple way to get rid of
| them all at once?