Question about Computers & Internet
I am trying to sort a field containing both first name and last name, the trick is i want to sort it by last name?
how do i do it because so far it is only letting me sort it by first name. and i need them in the one column
If you are doing this in Excel - Use Data - > Text to columns after selecting the first column (ie FN + LN)
This will split Last name to next column, Sort the spread sheet on Last name.
Concatenate Last Name and Firt Name into next column by wring a formula. The concatenation symbol for strings is &.
Hopes this help.
If it is in a table - You can do this with SQL
Posted on Sep 28, 2009
Are you using mssql then it must be something like this
Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname
Posted on Sep 27, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Sep 07, 2014 | Microsoft Excel for PC
May 22, 2010 | Microsoft Office Professional 2007 Full...
Feb 08, 2010 | Microsoft Office Professional 2007 Full...
Nov 09, 2009 | Microsoft Computers & Internet
Nov 02, 2009 | Microsoft Outlook Express
May 09, 2008 | Microsoft Office Outlook 2003 for PC
Feb 03, 2008 | Microsoft Excel for PC
Jan 04, 2008 | Computers & Internet
Aug 20, 2007 | Microsoft Office Standard for PC
249 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: