how i can aarange names in alphabetical odders
|
I assume you mean that you first and surnames in a cell and you want to sort
on surnames. You will need to extract the surname into a separate helper column, using MID and FIND functions (an example assuming names like John Smith, =MID(A1,FIND(" ",A1)+1,99), and then sort both columns on the surname column. -- HTH RP (remove nothere from the email address if mailing direct) "ADNAN" wrote in message ... |
All times are GMT +1. The time now is 12:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com