On 7 Nov, 11:54, "Niek Otten" wrote:
Look at the CLEAN function. You mat also want to look at David McRitchies TRIMALL function:

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


Thanks for pointers, using WorksheetFunction.Clean and Trim seems to
have worked.

Ian