All
I have some address data that I need to 'concatenate'. issue is some of the addresses only have 1 cell of data while others have up to 5
how do I 'concatenate' so that there are no 'spaces' at the end of an address if only 1 cell for example has data.
I have approx. 2500 rows of addresses....
TIA
Shaz0503
Bookmarks