Thanks for that. I've tried it on a small sample of data and it works great. I've noticed that it doesn't to CLEAN the text (I don't know if it TRIMs it)
Will it still work if i use formulas to CLEAN and TRIM the text first or should i run the vba then CLEAN and TRIM?

I just want to make sure i dont mess things up because it'll be very difficult to see if something goes wrong until a customer complains!

Thanks again
John