ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do I convert a column last name first and in assending order? (https://www.excelbanter.com/excel-worksheet-functions/104761-how-do-i-convert-column-last-name-first-assending-order.html)

Cathy ANDREWS

how do I convert a column last name first and in assending order?
 
I am using a XL Spreadsheet. I would like to convert the list of last names
in column A into alphabetic order.

JMB

how do I convert a column last name first and in assending order?
 
click Data/Sort, sort by Column A - ascending. If you have a table and want
the entire table sorted by last name, then you will need to select the entire
table before sorting, otherwise column A will get sorted, but the rest of
your data will remain as is.

Be sure to back up your data.

"Cathy ANDREWS" wrote:

I am using a XL Spreadsheet. I would like to convert the list of last names
in column A into alphabetic order.



All times are GMT +1. The time now is 10:13 AM.

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