BC,
Try highlighting column A. Then from the top menus, select Data, Text to
Columns, delimited, Next and, then, depending on whatever is separating the
info, select the delimiter. Then Finish.


"BCLivell" wrote:

I have an excel worksheet that someone provide me. All of the information is
in 1 column (A) with each row having the person's contact info. The pattern
repeats for each contact. The pattern like this

A1-Company name
A2-Name
A3-phone

There are 100 contacts in this format. I need to seperate all of the
information so that the comany name is one column and the name is an another
column and the phone is in a third column. I can not figure out how to do
this. Thank you!!!