Imported data into Excel

[ezeetyger]

we have a wonderful programme at work that does not let us mailmerge
which is a real pain in the butt. The only way we can even remotely
have a chance is by exporting the data into Excel. However, this also
causes a proble as all the addresses go into one column. So instead
of having;


Column1 Column2 Column3 Column4 Column5 Column6
Column7

Mr Jack Jones 1 Lincoln Court Leeds Yorkshire
LS25 1WW

I get.......

Column1 Column2 Column3 Column4
Column5

Mr Jack Jones 1 Lincoln Court Leeds Yorkshire LS25
1WW

How can I get Column4 split correctly? I export as a text file (csv I
think) and then use comma as the delimiter, but it doe snot split the
data correctly. I think its because that when you input the address
in the original programme the address box relies on the ENTER key to
get the next line

Thanks

 

[BrianB]

My experience is that mailmerge requires all the data to be in table
format with each address in a single row with separate fields used for
each line of the address - so what you state as your requirement might
be incorrect. It is unusual to have the name & address in one line. You
do not state how you expect to do the mailmerge. Usually by printing
self adhesive labels.

You are correct in saying that the Enter/LineFeed character (code 10 I
think) forces the new line.

In your situation would rebuild the data into another sheet using
formulas or a macro, this would then enable the data to be put into the
proper columns for conversion to address lines.