ST Alpha - "I am trying to conver a Word doc with tables to an Excel worksheet. When I copy one row from the doc to the xls file, it converts to multiple rows." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 153

I am trying to conver a Word doc with tables to an Excel worksheet. When I copy one row from the doc to the xls file, it converts to multiple rows.

Posted by GregW (aka not2fast) Jun 25 '13, 13:23

Some of the cells contain several lines of text. Instead of storing it all in one cell on one row like it is in the doc file, excel converts each line to a separate row.

I have tried the paste special options using both 'keep source formatting' and 'match destination formatting'. Both of them do the same thing.

Responses:

there are tips/instructions out there for just this. nm but: -- (link) - b. Jun 25, 13:50
Are there formatting options w/i the Word cells? - OAE -- Explorer, Antarctica, Old Jun 25, 13:25 5
- Thanks, I finally found the option to display formatting. I hate how they hide these options in 2010. -- nm - GregW Jun 25, 13:49
- How would I know if there are formatting options in the cells? -- nm - GregW Jun 25, 13:26 3
  - and how do I delete them? -- nm - GregW Jun 25, 13:31 2
    - select just the table then ctrl-h (replace). change ^p (paragraph mark) to a space -- nm - zork Jun 25, 13:54 1
      - or did you want to retain the line breaks within the cells? -- nm - zork Jun 25, 13:59

Post a message top

I am trying to conver a Word doc with tables to an Excel worksheet. When I copy one row from the doc to the xls file, it converts to multiple rows.

Replies are disabled on threads older than 7 days.