Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
BecG
 
Posts: n/a
Default Paste rows of numbers from Word into single Excel cell

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?
Also separated the numbers in Word with the manual line breaks instead of the paragraph marks, but same result in Excel.
Can a "hard carriage return" be used in global replace in Excel? Also replaced the paragraph mark in Word with a dash and pasted in Excel. It pasted into one cell as a text string. Planned to use global replace to replace the dash with a hard carriage return to break the numbers into rows in the single cell. However, I cannot paste the hard carriage return in global replace or find a symbol to use.

  #2   Report Post  
richdsn2
 
Posts: n/a
Default

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.

"BecG" wrote:

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?
Also separated the numbers in Word with the manual line breaks instead of the paragraph marks, but same result in Excel.
Can a "hard carriage return" be used in global replace in Excel? Also replaced the paragraph mark in Word with a dash and pasted in Excel. It pasted into one cell as a text string. Planned to use global replace to replace the dash with a hard carriage return to break the numbers into rows in the single cell. However, I cannot paste the hard carriage return in global replace or find a symbol to use.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 4 April 25th 23 11:47 AM
How can I use word wrap in a merged cell in excel 2000? PartnersHC Excel Discussion (Misc queries) 4 October 18th 09 10:02 PM
IN EXCEL, WHEN I CLICK ONA SINGLE CELL It HIGHLIGHTS WHOLE Page confused Excel Discussion (Misc queries) 2 December 7th 04 10:41 PM
how do i set up a single cell continual entry in excel to total f. mike@swallow Excel Discussion (Misc queries) 1 December 7th 04 01:29 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 09:58 PM


All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"