PDA

View Full Version : Solved: Cut from Word and paste in Excel



austenr
05-10-2007, 11:57 AM
When I copy and paste the following from Word to Excel:


The Auto-Fill Award contains two options.
? Full: Populates all the categories and dollar amounts.
Categories only: Populates only categories without dollar amounts.

it populates the entry in three cells. This is copied from a word table. Is there a way to keep it all in one cell? I have tried all of the Paste Special options and none seem to work. Thanks

Oorang
05-10-2007, 12:21 PM
Yup press F2 in the cell you want to paste in. Then press ctrl-v. (Another words paste into the formula bar.)

austenr
05-10-2007, 12:28 PM
Thanks. Knew it was easy just didn't know.

Oorang
05-10-2007, 12:49 PM
:content: