Paste without including cell borders
 

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.

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 formattingalignment

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

"Heath" wrote:

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.