copy and paste and make data fall into respective cells

Hi, i was trying to paste a list from a website into excel.
data like:
AOL Inc. New York,
ABC, Inc. New York, NY United States 1,638
IAC/InterActiveCorp New York, NY United States 1,637
White & Case LLP New York, NY United States 1,307
Madison Square Garden, Inc. New York, NY United States 1,157
Take-Two Interactive Software, Inc. New York, NY United States 1,137
Duff & Phelps Corporation New York, NY United States 375
Public Health Solutions New York, NY United States 226
New York City Health and Hospitals Corporation New York, NY United States 65
New York City Economic Development Corporation

i wonder whether there is any way i can do to make all this data fall into respective cell in the same column? like AOL has its own cell, then ABC is in the cell below AOL.

Many thanks again!

Have you tried Data - Text to columns and use a comma as a delimiter?

Thank for your reply. However, i was not trying to separate the data into column. I wanted the data to fall into respective consecutive cell in the same column. Please help. I really appreciate it.

Originally Posted by martindwilson

works if i just paste not paste special text

the text are in the order, but i want the data to be in separate cell next down to each other.

i mean
A 46: AOL Inc. New York,
A 47: ABC, Inc. New York, NY United States 1,638
A 48: IAC/InterActiveCorp New York, NY United States 1,637

Umm this is weird. Maybe it is the website problem? the website was Hoovers

martindwilson, sorry for the late reply. yes that was the website.

I will have to pay if i want the download tool. I think it is ok now though. Thank you for your help, you have been very helpful