Paste without including cell borders

[Guest]

I have columns of names that I am trying to paste into other programs but I
don't want the cell borders to appear. I would like the data to all be
combined as one cell, so to speak. When I copy the column and paste it into
Word the cell borders remain in place. Is there any way to fix this so that
when I paste the data it will appear as one long line of names? Thank you in
advance for any help.

 

[Guest]

Do you mean border or gridlines? If you mean that you want to copy multiple
cells into a single cell it's not possible without VBA, you can however paste
them
normally and then use a formula and a help column/row to "merge" them,

=A2&CHAR(10)&A3&CHAR(10)&A4etc

then turn on word wrap under formatting>alignment

if you meant border as a formatted border you can just paste special
and select "all except borders"

Finally you can remove the gridlines

Regards,

Peo sjoblom