ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can I sort names in a column by the last name if it is typed last (https://www.excelbanter.com/excel-worksheet-functions/112033-can-i-sort-names-column-last-name-if-typed-last.html)

lanajv

can I sort names in a column by the last name if it is typed last
 


Tieske

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





All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com