View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Carolyn Carolyn is offline
external usenet poster
 
Posts: 60
Default Copy text from word with returns into one cell

Thank you. Is there any way to get around this? I tried creating a macro
where I copied text out of one cell, went to the previous cell and put in an
alt return and them pasted into the previous cell. It didn't work.

"Gary''s Student" wrote:

Normally the line-break within the table cell in the Word document will paste
into two separate cells in Excel.
--
Gary''s Student


"Carolyn" wrote:

I have several rows of text in a cell in Word table (divided by manual line
breaks). I would like to copy that text into one cell in Excel. Is there a
way to do that or will it only copy each line in the Word table cell to
individual rows rather than a cell in Excel?

Carolyn