0
Take an example of a first name and a last name. If both names are in one cell, it cannot be easily done. What is best to do is to put the first name and last name in separate cells, and then sort on the last name, by selecting the two columns, starting by selecting the second column first and then the first, so both are selected. If you want to show the two names in one cell, you can then in a third cell display the two together. If the first name was in A2 and the last name in B2 then in C2 you could have the following formula:
=A2&" "&B2
If they are already in a single cell, it is difficult to split them and there is no 100% accurate way of doing it. The basic idea is to look for the first space and then take the remaining element of the cell. That assumes that the first space you come to is the end of the first name and immediately before the last name. The problem is that sometime people have a two part first name, so the first space would be in between them and not the end of the first name. Most names just have one first name and one last name. So you could use the following formulas to split the first name into one cell and the remaining content into a second cell. You would then have to manually go through and adjust any that were wrong.
Assuming all of the name is in A2, the the following will get the first name out, if put into another cell, say B2:
=LEFT(A2,FIND(" ",A2)-1)
In C2 you would put:
=MID(A2,FIND(" ",A2)+1,LEN(A2)-FIND(" ",A2)+1)
Copy both formulas down for all names. Then select the full set of both formulas and co a Copy. Put the cursor on B2 then and select Paste Special and then tick Values and click OK. You will now safely have the two sets in columns B and C. You can safely get rid of values in column A. If you had not done the Copy and Paste Special, when getting rid of the values in column A, the values in column B and C would also be lost. Now you can go through the values in columns B and C and change any that are wrong.
What else can I help you with?
What is column break in Microsoft Excel?
A column break is a term associated with Microsoft Word, not Excel. In Word, it starts a new column of text. In Excel, you can just go to another column to start entering new data.
In word Excel 2007 what are the last three letters of the columns?
XFD is the column label on the last column in a Microsoft Excel 2007 worksheet.
How do you alphabetize something in Excel so it ignores the word the?
I'm not sure you can (easily) short of writing a macro to do it. Have you considered writing, for example, 'The Thing' as 'Thing, The'? This should work.
How do you put words in alphabetical order on Microsoft Word?
If you have something like a list of words, you could enter them into cells in a table, in a column and then sort the table by that column. The option is amongst the options available for tables. You can then remove the table if you don't need it, leaving the text sorted.
Make a sentence with the word alphabetize in a compound?
A compound sentence is a sentence with two separate clauses, that could be made into two sentences. The clauses are often linked with a conjunction like 'and' or 'but'. Alphabetize means to arrange in alphabetical order.Can you alphabetize this list of words for me and then put them into a database.
Can you column break in Microsoft Excel?
Not in the sense that you do in Microsoft Word, but you are free to arrange the data in whatever way you want, so you can have data start in a new column when you need to. A column break in Word is used to put continuous text into a new column. Spreadsheets don't tend to have large amounts of continuous text, so it is not required in Excel.
Word inserts what when you switch from one column format to two column format?
a second column
What word means to organize or index?
Categorize, or alphabetize.
How do you EXCEL Trying To Link One Word In Column B To Input A Different Word In Column G For Example Column B Is A Product Name. Column G Is The Chemical Composition. When Ever The Word product Is I?
It looks as if you want to do a lookup - look up data in a table, in one column, and return the value next to it, in another column. The vlookup() function does just that.
How do you use the word alphabetize in a compound sentence?
"You should alphabetize the list, and then remove any duplicate entries." "The teacher wanted to learn her students' names, so she would alphabetize them to create the seating arrangement in class."
How do you print a graph paper in Excel or word?
In Excel, you can set the column width to 2 and display borders around the cells of the number of cells you would like to display on your graph paper, then print.
How do you stack information in a cell in Excel?
You need to format that cell and allow word wrap. That will enable you to say type two words like Grand Total and if the width of the column is set for the width of the word Grand then the word Total will automatically stack under as a second line. But this will change the Row's Height.
