Question about Computers & Internet

2 Answers

Sorting a single column with both first name and last name

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

Posted by on

  • pasimeon Sep 26, 2009

    It is plain text in a microsoft access 2003 table file. one column containing both first name and last name. but it only lets me sort by the first name and i want it sorted via last name.

  • Mike Blyth May 11, 2010

    You will need to give more details about what you are doing. What kind of file are you trying to sort--plain text, tab delimited, Excel, or what? And what program are you using to sort it? How big is the file? How are the last and first name separated? It would be helpful to show one or two lines of the file as examples.

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 13 Answers

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

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 103 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have a column containing a value of a single letter. I need the spreadsheet to sort add rows by letter.


Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

Sep 07, 2014 | Microsoft Excel for PC

2 Answers

In Outlook 2007, the current address cards view sorts by the File As: field, that has the default last, first. I wish to sort by first last name order. I can do this by changing it in the File As: field...


try selecting one contact and holding down CNTRL (control) and push the "a" key (cntrl + a) . this will select all contacts. for control all. make changes after all contacts are selected. hope this helps.

May 22, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

When creating a new email in Outlook 2007, if I click on the "To" button to pull up an address from my Contacts they are alphabetized by First Name. How can I get them listed by Last Name?


To setup up contacts by the person's last name. In Outlook, when you compose a new message, and then click the To or Ccbutton, the Contacts list may display names that are sorted by the contact's first name. Here's how you can change the list to display entries by the contact's last name.
Sort the Contacts list by the File As field
  1. Start Outlook.
  2. On the Tools menu, click E-mail accounts.
  3. Click View or change existing directories or address books, and then click Next.
  4. Click Outlook Address Book, and then click Change.
  5. Under Outlook Address Books, click Contacts: Mailbox -YourMailboxName, and then under Show names by, click File As (Smith, John).
  6. Click Close, and then click Finish.
Verify that the newly created contacts are filed in last name, first name order
  1. On the Tools menu, click Options.
  2. Click the Preferences tab, and then click Contact Options.
  3. In the Default "File As" order list, click Last, First.
  4. Click OK twice.
  5. To view the new Contacts list sort order, restart Outlook.
NOTE If you want to display a particular contact in a different order than the rest of the Contact list, you can modify the File As field in individual contact cards. For example, you may want to sort some contacts by the Company field.

Feb 08, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

1 Answer

Doesn't remember there's a Header Row


You can try to select all data (except for the entire row which contain your header) and try to sort thru columns. This can sorted in ascending or descending order.

Jul 17, 2009 | Microsoft EXCEL 2004 for Mac

3 Answers

Change display of contacts to first name, last name in outlook 2003


In most phones, there is an 'options' or 'preferences' in the address book that allows you to sort by first name, last name, etc.

As far as Outlook goes, when you are in the contacts tab, there is a link on the left that says "customize current view". Click on this and you can select fields to pick what fields you want displayed or select sort to pick how they are displayed.

May 09, 2008 | Microsoft Office Outlook 2003 for PC

1 Answer

Lookup,s


If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.
To do this, do the following:
1) Move the C Column to be the A Column, shifting all other columns to the right.
2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)
3) Use A1 as your search field.
4) In A2, enter the following formula:
=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:
$A$1 -> the search field (name your looking for).
$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.
3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.
Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

1 Answer

Sorting within a column


This page covers how to manipulate columns when the data is formatted as "LastName, FirstName MiddleName"... I'm guessing you could just tweak it:
http://www.cpearson.com/excel/FirstLast.htm

This google group goes more in depth on the topic:
http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/49bf87ffdc31a9d3/954544ded2b2f620#954544ded2b2f620

Jan 04, 2008 | Computers & Internet

1 Answer

Merging Data in 2 Separate Excel Workbooks


If the First Name and Last name are equal to both work sheets, I will just sort them by First Name and Last name and copy the results into a separate work sheet. If the names are different you will have to use Access: This can be easily done with Access and SQL, just import both work books into different tables to access and use the create query wizard, play with the results until you will get the result you want. Access will also solve the duplicate problem easily. Very important: You will have to use join properties: Read help about join properties and understand how this works... Afterward you can export it back to Excel or use Copy/Paste. If you can't use Access and have only Excel: You will have to use Vlookup on various fields until you will get the result you want. Its a hard work but in the end you will get the same result as access. Let me know what happend Daniel

Aug 20, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

249 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...