Group:  Microsoft Excel ยป microsoft.public.excel.worksheet.functions
Thread: can I sort names in a column by the last name if it is typed last

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

can I sort names in a column by the last name if it is typed last
lanajv 28.09.2006 16:17:01

Re: can I sort names in a column by the last name if it is typed last
"Tieske" <not[ at ]here.com> 28.09.2006 22:12:29
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" <lanajv[ at ]discussions.microsoft.com> wrote in message
news:18BA32B9-3CDE-4708-BF35-B57F28BE33CA[ at ]microsoft.com...
[Quoted Text]
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net