Hello,

OK, having split my address column into separate columns for each line, I'm
now left with leading spaces in the 2nd and subsequent columns.

How do I remove these leading spaces?

I've experimented with the =TRIM() function and can happily create a
duplicate list on the same worksheet, but that's no good to me - I want the
TRIMmed data to be the only data so that I can use it for my mail merge. I
can't delete the original data, or move the TRIMmed data, because the =TRIM()
function no longer works, of course.

There must be some simple way to edit the whole worksheet to remove any
leading spaces in the cells, or some way of using =TRIM() to do it.

What have I missed this time? :)

Thanks.