Hi, I have some customer data that has been imported into an excel sheet. The data looks like this:
contact company address
address
address
I need to move all the address data onto the same rowas the rest to individual columns. The number of address lines changes for each customer. I cannot modify the data before importing it into excel. When it is imported each field is delimited with a semi-colon. The address lines are all in 1 field (free form text). I need to use the data in a mail merge with Word. At the moment I get a page for each of the address lines as it treats them as new data as they are on different rows.
Any suggestions greatly appreciated
Richard
