SORTING
Hi everyone,
I neglected to seperate first and last name in my table and now I need to alphabetize by the last name. Is this possible when the first and last name are in the same field(table) thanks RW |
SORTING
You can break the two names out into their own columns and sort that way, or,
Jim Cone has a nifty little inexpensive commercial Add-in that I use, called "SpecialSort" that will do the trick in the one column. It's available at http://www.realezsites.com/bus/primi...e/products.php Vaya con Dios, Chuck, CABGx3 "Ransom" wrote: Hi everyone, I neglected to seperate first and last name in my table and now I need to alphabetize by the last name. Is this possible when the first and last name are in the same field(table) thanks RW |
SORTING
You'd have to separate the first name and last names into different columns and
then sort by them. Depending on what those names look like, maybe a simple data|text to columns would work???? Ransom wrote: Hi everyone, I neglected to seperate first and last name in my table and now I need to alphabetize by the last name. Is this possible when the first and last name are in the same field(table) thanks RW -- Dave Peterson |
All times are GMT +1. The time now is 06:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com