View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bkrcove bkrcove is offline
external usenet poster
 
Posts: 1
Default how to preserve paragraph breaks in pasted text?

A quick way of doing this if you only have a small amount of text to paste is
to copy it from Word and paste it into the Formula Bar in Excel instead of
into the cell. I have tried this and Excel converts even hard paragraph
breaks in Word into soft paragraph breaks in Excel, which is what we want.