try to copy and paste data in column format to excel into the same cell

**cyl90089** · 08-20-2011, 01:50 AM

Hi,
I am trying to copy and paste some information from a website, into excel. Information like
1234, Lex Street,
345, New York,
New York City, 10022.

I wanted to paste the info into excel in the same cell, but for some reason the info goes into separate cell in the same column. Could somebody help me out here?
Thank you so much!

**Azam Ali** · 08-20-2011, 01:58 AM

press F2 or space before pasting the data

i.e. first copy the data from web then in the required cell in excel press F2 and then paste the data.

**lexie** · 08-20-2011, 02:19 PM

I tried and i couldn't do it. My Excel is 2010. Any thoughts?

**martindwilson** · 08-20-2011, 02:37 PM

paste it directly into the formula bar
note to use f2 you must select the cell first
or select cell click again to get cursor in it then paste

**lexie** · 08-20-2011, 02:42 PM

Thank you so much that helps!

**ZENITH** · 08-20-2011, 04:14 PM

If you were satisfied with your answer please mark the thread solved, directions below:

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save