Move info to columns

[fguardia]

I am having trouble moving a list of people from colum A and have ot move the fields over to other columns. IE:


NAme LAst, CLTC
75 Second Ave, Suite 330
Needham, MA 02494
Company: Mass Mutual
Renewal Date: 2/1/2011
Phone number: (781)292-3303
Email: [email protected]

COlo Molo, CLTC
373 Cornflower Drive
Columbia, SC 29229
Company: Physicians Mutual Insurance
Renewal Date: 4/1/2010
Phone number: (803)387-7935
Email: [email protected]

Cholo Colo, CLTC
780 Carillon Parkway
St. Petersburg, FL 33716
Company: Allstate Financial Services
Renewal Date: 2/1/2010
Phone number: (999) 999-9999
Email: [email protected]

How do I have excel split each contact info over to separate columns? Like moving the phone number email, etc. I have tried the text to columns and I am still having trouble..

[Cheeky Charlie]

Are the details exactly the same length each time?

Please upload an example workbook (whether the answer is yes or no)

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[fguardia]

Are the details exactly the same length each time?

Please upload an example workbook (whether the answer is yes or no)

Yes they are all the same. I do not know how to upload what you ask . can you help.

[Cheeky Charlie]

Sorry, you'd need to comply with Roy's request before I can help you more - remember, better thread titles make the forum a better resource for searching, it also means good solutions get a bigger audience.

What you want is pretty simple, I don't need an example if they are exactly the same length...