I need to upload a bunch of information for cold calling, and I have no
idea how to use excel formulas. I am trying to take information from an
online source like the yellow pages and upload it into an excel spread
sheet. however I need Company Name, phone number(just numbers), and
address to go into different cells.

I need Company name to go into column A, First Name in Column C, last
Name in Column B, Phone Number in Column's D-F(three numbers per
column), fax number in colum's G-I (three numbers per column), and cell
number in J-L(three numbers per column), website address in M, e-mail in
N, Address 1 in O, address 2 in P, city in Q, State in R, Zip in S, for
colums T and U I need to be able to have one set info for all
listings.

I want to copy the info from a site like this:
http://tinyurl.com/k3v6a

If you can Help, I would greatly appreciate it.


--
Isaac_m911
------------------------------------------------------------------------
Isaac_m911's Profile: http://www.excelforum.com/member.php...o&userid=34686
View this thread: http://www.excelforum.com/showthread...hreadid=544496

Sorry, as with Spammers, I don't think I can support Cold-Callers, even
if you do operate in a different continent and are unlikely to call me!

Pete

I said lists that are similar to the one shown. I have lists from
associations that our company works with, that we have agreements with.
These lists of there members that have to be contacted have to be
uploaded into our database. We are not just cold-calling random people,
we work with only qualified people that know that they are going to be
contacted. This is why my needs in the original message include all
information not just a name and a number.


--
Isaac_m911
------------------------------------------------------------------------
Isaac_m911's Profile: http://www.excelforum.com/member.php...o&userid=34686
View this thread: http://www.excelforum.com/showthread...hreadid=544496