G
Guest
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.
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.