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?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
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.
works if i just paste not paste special text
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
the text are in the order, but i want the data to be in separate cell next down to each other.Originally Posted by martindwilson
????? do you mean like this
AOL Inc
New York,*
ABC, Inc.
New York,
NY
United States
1,638
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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
this is what happens if i select your data copy and paste into a1
now it maybe your source data is different what is the website?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Umm this is weird. Maybe it is the website problem? the website was Hoovers
this one?
Hoover's, Inc. offers business information through the Internet, data feeds, wireless devices, and co-branding agreements with other online services. ; and information download tool that allows users to import data into spreadsheets, CRMs, and other software for analysis of companies, competitors, and customers. It...
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
martindwilson, sorry for the late reply. yes that was the website.
so have you tried the download tool?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks