Save your data and use a copy for this exercize........
Be sure the column to the right of your column is blank, or insert a new
one...........
Highlight the column with the names, then do Data TextToColumns
Delimited Next check the SPACE box finish
This splits the surname over to the blank column

or

If your data in column A, put this in B1 and copy down.........
=MID(A1,FIND(" ",A1,1)+1,99)
This will put the surname in column B, leaving column A intact

Vaya con Dios,
Chuck, CABGx3



"Curious Lady" wrote in message
...
We already have the data base and I understand what you are telling me to
do;
however, I am not familiar with the "TextToColumns" feature or the "MID"
formula. Where would I find this and can you suggest a good question to
ask
Mr. Wizard Help? Thank you for your time.

"CLR" wrote:

If you have not created the DataBase yet, then by all means use separate
columns for the first and last names.......it's so much better in the
long
run........if you already have such a list, then it's best to separate
it
with the "TextToColumns" feature or the "MID" formula..............

Vaya con Dios,
Chuck, CABGx3

"Curious Lady" <Curious wrote in message
...
If I create a data base with a name cell that includes both the first
and
last name, can I sort by the first letter of the last name?