ExcelBanter - Formula to sort names in alphabetical order?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to sort names in alphabetical order? (https://www.excelbanter.com/excel-discussion-misc-queries/43466-re-formula-sort-names-alphabetical-order.html)

Fredrik Jonsson

Formula to sort names in alphabetical order?

Just press Data and then Sort...

"Christina" wrote:

What formula do I use to sort names in Excel? The list is typed with the
whole name in one cell ex. "Dave Smith", "Chris Johnson". I need to sort the
list by the last name or somehow re-arrange the names to use the sort feature.
--
Christina

All times are GMT +1. The time now is 08:58 PM.