P
Pete
Hi I have 5000+ rows in my sheet the columns are as
follows -
A - Name
B - Unique Reference
C - Address Ln1
D - Address Ln2
E - Address Ln3
F - Address Ln4
G - PostCode
How can I get column H to bring to gether all the address
info into one column and be of the layout like this -
NAME, ADDRESS Ln1, ADDRESS Ln2, ADDRESS Ln3, ADDRESS Ln4,
POSTCODE, UNIQUE REFERENCE
Any help is much appreciated I cannot seem to keep all
the info together using the merge button and I dont know
how to programatically enter the commas to seperate the
results in the single cell.
Pete
follows -
A - Name
B - Unique Reference
C - Address Ln1
D - Address Ln2
E - Address Ln3
F - Address Ln4
G - PostCode
How can I get column H to bring to gether all the address
info into one column and be of the layout like this -
NAME, ADDRESS Ln1, ADDRESS Ln2, ADDRESS Ln3, ADDRESS Ln4,
POSTCODE, UNIQUE REFERENCE
Any help is much appreciated I cannot seem to keep all
the info together using the merge button and I dont know
how to programatically enter the commas to seperate the
results in the single cell.
Pete