PASTING WORD TO EXCEL

[mark.wakeman]

Help needed!!

I am trying to past text from a word table into an excel cell. The word
table text has returns in it and when I paste it into excel each line goes
in a different cell (most annoying).

I then took out all the returns and pasted the text in, but no matter what I
do to the formatting of the excel cell, I can't play with the text as I
would like to. When I paste the text into excel the cell just displays
xxxxxxxxxxxxxxxxxxxxxxxxxxx.

Can anyone help me and tell me how to transfer the text from a word table
cell to an excel cell. Also, is there a limit to how much text an excel
cell can hold, and can this be changed.

Thank you

 

[JE McGimpsey]

Help needed!!

I am trying to past text from a word table into an excel cell. The word
table text has returns in it and when I paste it into excel each line goes
in a different cell (most annoying).

I then took out all the returns and pasted the text in, but no matter what I
do to the formatting of the excel cell, I can't play with the text as I
would like to. When I paste the text into excel the cell just displays
xxxxxxxxxxxxxxxxxxxxxxxxxxx.

Can anyone help me and tell me how to transfer the text from a word table
cell to an excel cell. Also, is there a limit to how much text an excel
cell can hold, and can this be changed.

Per the specifications (Help/Specifications), an XL cell can hold 32767
characters, of which 1024 can be displayed (in fact, more can be
displayed if manual linebreaks are added before each 1024 characters).

Note that not all clipboard sources can copy that many characters.

You can paste all the characters in the clipboard into a cell by
clicking in the Formula bar, or double-clicking in the cell, to enter
Edit mode, then pasting.

 

[Sue]

-----Original Message-----


Per the specifications (Help/Specifications), an XL cell can hold 32767
characters, of which 1024 can be displayed (in fact, more can be
displayed if manual linebreaks are added before each 1024 characters).

Note that not all clipboard sources can copy that many characters.

You can paste all the characters in the clipboard into a cell by
clicking in the Formula bar, or double-clicking in the cell, to enter
Edit mode, then pasting.
.

Having said this, how do you know when you've reached 1,024 characters
and 32,767 characters?

 

[JE McGimpsey]

Having said this, how do you know when you've reached 1,024 characters
and 32,767 characters?

Use

=LEN(A1)