Imported data into Excel

  • Thread starter Thread starter ezeetyger
  • Start date Start date
E

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
 
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.
 
Back
Top