Question about Computers & Internet

1 Answer

Sorting within a column

I have a list of names in a column with the first name, middle name, then last name - all in the same column. I know there is a way to change it so the last name is first, but I can't remember how.

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 167 Answers

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

Posted on Jan 04, 2008

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Do not have pin. How do I create one?


The best way to make PIN, especially one you won't forget, is to find out the numbers your last name letters correspond to from a phone. For instance, since your last name is Fomin, the numbers from the phone are 3,6,6,4,6. To make it more secretative, make it backwards.
I suggest you use your middle name cause most people don't let everybody know there middle name.

Jan 19, 2018 | Cell Phones

1 Answer

I just purchased an IPhone. I have had Androids for years. My contacts are sorted by different words THEY think are important. Can I fix it to list alphabetically?


How to Arrange Contacts Alphabetically on an iPhone 5 ' Chron.com

smallbusiness.chron.com > Setting Up a New Business > Steps for Starting a Business
  1. Cached
  2. Similar
Tap "Mail, Contacts, Calendar" and then scroll to the Contacts section. 4. Tap "Sort Order" and then tap "First, Last" to sort your contacts alphabetically by first name. This is useful if you tend to think of people by their first name, such as friends and family members.

How to Sort Your iPhone Contacts by First Name: 4 Steps - wikiHow

https://www.wikihow.com/Sort-Your-iPhone-Contacts-by-First-Name
  1. Cached
It should sort your contacts alphabetically by default, but if you want to sort them by the first name instead of the last, you can do so by going to Settings and then to Contacts. Then there should be an option so change the sorting order.

How to Sort the Contacts on Your iPhone - dummies

www.dummies.com/consumer.../iphone/how-to-sort-the-contacts-on-your-iphone/
  1. Cached
  2. Similar
You can sort the contacts you have stored on your iPhone alphabetically - either by their last names or their first names. Choosing which method to sort your contacts allows you to find people quicker, based on whichever sorting method you prefer. Tap Mail, Contacts, Calendars, scroll down to the Contacts section, and ...
iphone contacts list alphabetically Google Search

Jan 11, 2018 | Cell Phones

1 Answer

Mother maiden name


In the United States culture, women have had usually 3 names for the last about 100 years or so.
Occasionally a middle name was left out.
The name on their birth certificate was their first name, their middle name, and their family name.
For example, Mary Elizabeth LaTruce.
This would have been her name until she married, at which time she would have changed the last, or family name, to that of her husband. Mary Elizabeth LaTruce would have become Mary Elizabeth Diverse. The name she received as a child on her birth certificate was her "maiden name".

Oct 09, 2015 | Cell Phones

2 Answers

Change facebook username


Log in to your Facebook account, click the little gear icon in the upper-right, click "Settings," then click the "Edit" to the right of the "Name" line.

Feb 01, 2014 | Computers & Internet

2 Answers

Sorting a single column with both first name and last name


are you using mssql then it must be something like this

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

Sep 26, 2009 | Computers & Internet

1 Answer

Excel


Hey dude,

Select both the columns and click on Auto-filter option. This will give you a drop-down list box to select data of your choice.

Sep 06, 2008 | Computers & Internet

1 Answer

If function in exel


For Current Date - you can use the =Now() function in your cell where you want the date.

For Contract #, I don't know what you're using, but you can link to a database of contract #s (see below), or you can name a range like current contract #, which gets updated by 1 each time you add another contract, which then is automatically posted on your EXCEL



DGET(database,field,criteria)
Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Jul 15, 2008 | Microsoft Excel for PC

1 Answer

Unassigned Users


Unable to answer your problem without more information. Is this a database? What program? Or users on a computer? Is it possible to undo what you did? For future reference, pressing the control key and the Z key will undo whatever you just did. This will usually work for several edits backwards. Probably too late to help, but you should have a backup of the databases (if that is what this is). Download or copy/paste it to replace the one that is messed up. Then it is easy to look up on the Internet how to do almost anything to do with databases. If it is a simple database, be sure to keep your backup intact (that's why you copy/paste and not cut/paste) and try grabbing the top of the last name column and drag it to the other side of the first name column. If that doesn't work, cut the column and then paste it on the other side.

Oct 02, 2017 | Veramark Avaya eCAS for IP Office...

1 Answer

Using NOW() in excel formula


That sounds like Excel. You may have to get someone locally to fix that problem.

Jun 10, 2008 | Microsoft Windows XP Professional

1 Answer

Sorting string


If you are using windows XP, click the start button. Choose 'Run' , type : cmd
and press enter to open a dos command window. Inside the dos command window, type the command: sort
then press enter.
enter some names and press enter after each name like:
john
terry
bill
howard
arthur
gary
fred
^Z
Press control and z at the same time when you are finished and press enter. The names will be output in order

(In windows vista, just enter the command cmd in the search start and press enter)


To output the names to a file, type
sort > filename.txt
press enter and then do the same as above. The names will be in a file called filename.txt

Feb 28, 2008 | Microsoft AccRepair DS2 2004 for Fr...

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

Related Topics:

61 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...