Paste rows of numbers from Word into single Excel cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Am trying to copy a list of numbers from Word and paste into a single Excel
cell, and keep the numbers in rows. However, the numbers paste into separate
Excel cells in a column instead of a single cell. Any easy way to do this?
 
Have you tried to paste the numbers into the formula bar at the top (or
direct edit in the cell). If you select a single cell, and then paste, Excel
will auto spread your paste to different cells. You have to get into a
single cell edit function to paste, either by double clicking in the cell
untill the edit curser appears, or up in the formula bar.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Text To Numbers ? 1
Pasting a block of Word info into a single Excel cell 3
Copying a table from Word 5
Paste from word to excel, into one cell. 7
Problem Cutting and Pasting from SQL Table to Excel Sheet 1
Excel Convert word into numbers and back 4
Cut and Paste Text with CRLF into Single Cell 1
Macro to paste x number of times 4

Back
Top