V
vdemar
I am trying to make a contact list using excel. I have been entering
addresses of business' into excel in the following format:
ABC Company
123 Booton Rd
Beverly Hills, CA 90210
Phone: (555) 555-5555
Fax: (555)444-4444
I currently have over 20,000 business names in one single column and I was
wondering if there was a way that I can convert those addresses into seperate
rows separating them by: Name---Address---Phone #----Fax # without having to
copy and paste them or type them in individually
addresses of business' into excel in the following format:
ABC Company
123 Booton Rd
Beverly Hills, CA 90210
Phone: (555) 555-5555
Fax: (555)444-4444
I currently have over 20,000 business names in one single column and I was
wondering if there was a way that I can convert those addresses into seperate
rows separating them by: Name---Address---Phone #----Fax # without having to
copy and paste them or type them in individually