View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tieske Tieske is offline
external usenet poster
 
Posts: 14
Default can I sort names in a column by the last name if it is typed last

no, you can't.

But you could add a column and prepare a formula that extracts the last name
from the column with the whole name. Then sort on the newly created column.

Tieske


"lanajv" wrote in message
...