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