If the functions in the freely downloadable file at
http//home.pacbell.net/beban are available to your workbook

=ArrayReshape(A1:A300,100,3) array entered into B1:D100

Alan Beban

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!!!