Solved: Cut from Word and paste in Excel

[austenr]

When I copy and paste the following from Word to Excel:

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

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]

Yup press F2 in the cell you want to paste in. Then press ctrl-v. (Another words paste into the formula bar.)

[austenr]

Thanks. Knew it was easy just didn't know.

[Oorang]