Word to Excel Macro Help
Posted by Brett Holcomb on November 05, 2001 6:08 AM
I am trying to move a series of word documents into Excel. When I paste from Word into Excel, it puts the word text into a number of different cells. For instance, if I have:
1. Go outside.
2. Look around.
excel will put this into different cells (probably because of carriage returns) when I need these to be in the same cell (because of the type of spreadsheet I am creating). Is there a macro or anyway to combine these lines back into one cell or to prevent Excel from doing this when I paste fromWord? I have hundreds of these that I would rather not do by hand.
P.S. It doesnt matter to me if it ends up looking like 1. Go outside. 2. Look around I just needit in one cell