how do I alphabetize a list that is already in excel.
 

I have a project in excel. It is a list of names of all of our clients. I
need to put this list in alpabetibe order. The first name is first and the
last name is typed last. There is also address,phone numbers.etc. How can I
do this or can I not

how do I alphabetize a list that is already in excel.
 

Sort by Last Name, First name.

"alpha names" wrote:

I have a project in excel. It is a list of names of all of our clients. I
need to put this list in alpabetibe order. The first name is first and the
last name is typed last. There is also address,phone numbers.etc. How can I
do this or can I not

how do I alphabetize a list that is already in excel.
 

Hi alphanames,

How is your data set out? Are the names, addresses, phone numbers all
in one column or several columns?

Your list can definitely be sorted the way you want but there are many
different approaches depending on how your data is setup and equally
important is what outcome you wish to achieve.

HTH
Martin

"alpha names" <alpha wrote in message
...
I have a project in excel. It is a list of names of all of our clients. I
need to put this list in alpabetibe order. The first name is first and
the
last name is typed last. There is also address,phone numbers.etc. How can
I
do this or can I not

how do I alphabetize a list that is already in excel.
 

Martin W

The names are in one column, address is in another column, the state is in
another column, etc.

The column with the names is like this example John and Mary Smith

How do I alpha this.

Thank you

Carol

"MartinW" wrote:

Hi alphanames,

How is your data set out? Are the names, addresses, phone numbers all
in one column or several columns?

Your list can definitely be sorted the way you want but there are many
different approaches depending on how your data is setup and equally
important is what outcome you wish to achieve.

HTH
Martin

"alpha names" <alpha wrote in message
...
I have a project in excel. It is a list of names of all of our clients. I
need to put this list in alpabetibe order. The first name is first and
the
last name is typed last. There is also address,phone numbers.etc. How can
I
do this or can I not

how do I alphabetize a list that is already in excel.
 

Hi Carol,

Try this, assuming your names are in column A1 down.
Insert a helper column B, put this formula in B1 and drag
down to the end of your data.

=MID(A1,FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,100)

Provided that your names are all separated by a space (as per your example),
this should
give you the last names only in column B.

Now highlight ALL of your data and go to DataSort and select column B
ascending.

Hopefully that should be all. Just delete column B to tidy up.

HTH
Martin


"alpha names" wrote in message
...
Martin W

The names are in one column, address is in another column, the state is in
another column, etc.

The column with the names is like this example John and Mary Smith

How do I alpha this.

Thank you

Carol

"MartinW" wrote:

Hi alphanames,

How is your data set out? Are the names, addresses, phone numbers all
in one column or several columns?

Your list can definitely be sorted the way you want but there are many
different approaches depending on how your data is setup and equally
important is what outcome you wish to achieve.

HTH
Martin

"alpha names" <alpha wrote in message
...
I have a project in excel. It is a list of names of all of our clients.
I
need to put this list in alpabetibe order. The first name is first and
the
last name is typed last. There is also address,phone numbers.etc. How
can
I
do this or can I not

how do I alphabetize a list that is already in excel.
 

Be careful of the wrap if you copy and paste from this thread.
There is a space where the formula broke.

HTH
Martin


"MartinW" wrote in message
...
Hi Carol,

Try this, assuming your names are in column A1 down.
Insert a helper column B, put this formula in B1 and drag
down to the end of your data.

=MID(A1,FIND("|",SUBSTITUTE(A1," ","|",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,100)

Provided that your names are all separated by a space (as per your
example), this should
give you the last names only in column B.

Now highlight ALL of your data and go to DataSort and select column B
ascending.

Hopefully that should be all. Just delete column B to tidy up.

HTH
Martin


"alpha names" wrote in message
...
Martin W

The names are in one column, address is in another column, the state is
in
another column, etc.

The column with the names is like this example John and Mary Smith

How do I alpha this.

Thank you

Carol

"MartinW" wrote:

Hi alphanames,

How is your data set out? Are the names, addresses, phone numbers all
in one column or several columns?

Your list can definitely be sorted the way you want but there are many
different approaches depending on how your data is setup and equally
important is what outcome you wish to achieve.

HTH
Martin

"alpha names" <alpha wrote in message
...
I have a project in excel. It is a list of names of all of our
clients. I
need to put this list in alpabetibe order. The first name is first
and
the
last name is typed last. There is also address,phone numbers.etc. How
can
I
do this or can I not