I created a table with five columns. The first column I typed about 100 names first and last. Can someone please tell me how to sort this table so the last name will be first. I typed them in word. Is there a way to do this without retyping them. Thanks for your help.
I don't know a quick answer, but while you're waiting for one from somebody you may as well start sorting your list with cut and paste, moving one name at a time to where you want it. 100 names shouldn't take you more than half an hour..
Paste the column into Excel. Use Data> Text to Columns and select Delimited then on the next page of the wizard select "Space" this will split into two columns. Create a new column back in your word document and paste the columns back.
You don't need to mess about with excel, you can do it from within Word. Select your table. On the table menu click sort. Select options, then Sort Column only check box. I am assuming it is only one column.
I don't think that will work, as Blessed wants to change the order of the entry in each cell from first name and last name, to last name and first name.
Taff™'s method is the way to go. I have just had a play around and it does work, and I thank him, as this will prove very useful (I run a cub pack and I am always making lists of the cubs names for trips etc. and I am forever needing to change/edit them!)
If you created it in Word then you can easily sort it in Word - there is no need to involve Excel. First ensure that you have the Database shortcut showing. Right click on a spare place on the top of Word - if Database hasn't got a tick in it put one.
Now if you look at the new toolbar yo have selected you wil see A-Z for sorting normal & Z-A for reversing. Clicking the Z-A would achieve what you require if I've read your query correctly. Obviously whatever column you are sorting needs to be selected first.
Thanks for those - I'll have a detailed look when I get home tonight.
I think Taff™ and I are reading this problem diffrently to everybody else! I read it as Blessed had one column in a table with names in it, such as Andrew Smith in one cell, Joe Bloggs in the next (in the column), Pat Jones in the next and so on.
And what he wanted was for the table/column to read Smith Andrew, Bloggs Joe, Jones Pat and so on, and as far as I can see only Taff™'s solution will achieve that!
I guess we'll never now if Blessed doesn't come back to the thread!