You could use DataText to columns to break the cell into two columns then
sort on the last name.


Gord Dibben Excel MVP

On Thu, 23 Jun 2005 16:31:02 -0700, Curious Lady <Curious
wrote:

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?