How do I paste text data into ONE cell only?
 

I'm trying to paste text into ONE cell only. However, when I paste ("paste
special, text), it inserts the text into several cells.

I've previously copied entire resumes from Word docs and have had no problem
in pasting the info as text into one cell. I've never had to draw a text box
for this solution either.

I will be using an Excel template which will include thousands of copied and
pasted text entries. If drawing a text box is the answer, how can I format
cells in an entire column as text boxes?

Any help is greatly appreciated!

How do I paste text data into ONE cell only?
 

Click in the formula bar first, activating it, then paste -- it will go into
one cell only.
Bob Umlas
Excel MVP

"Pegcorp" wrote:

I'm trying to paste text into ONE cell only. However, when I paste ("paste
special, text), it inserts the text into several cells.

I've previously copied entire resumes from Word docs and have had no problem
in pasting the info as text into one cell. I've never had to draw a text box
for this solution either.

I will be using an Excel template which will include thousands of copied and
pasted text entries. If drawing a text box is the answer, how can I format
cells in an entire column as text boxes?

Any help is greatly appreciated!