| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I reverse an entire column of names that have the last nam.
how do I reverse an entire column of names that have the last name first,
first name and then middle name or initial .....in an excel workbook? Thanks! |
|
#2
|
|||
|
|||
|
Check out,
<Data <Text To Columns To separate the names into separate columns, and then, if you wish, you can concatenate them back into a single column. Post back with further questions. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "josie" wrote in message ... how do I reverse an entire column of names that have the last name first, first name and then middle name or initial .....in an excel workbook? Thanks! |
|
#3
|
|||
|
|||
|
Thank you so much! It took awhile but I just now figured out the wizard
thing and it worked. I would never have known where to start. Thanks so much! Josie "josie" wrote: how do I reverse an entire column of names that have the last name first, first name and then middle name or initial .....in an excel workbook? Thanks! |
|
#4
|
|||
|
|||
|
Josie
Check out Chip Pearson's site for formulas and a downloadable workbook with examples. http://www.cpearson.com/excel/FirstLast.htm Gord Dibben Excel MVP On Sun, 20 Feb 2005 12:15:02 -0800, "josie" wrote: how do I reverse an entire column of names that have the last name first, first name and then middle name or initial .....in an excel workbook? Thanks! |
|
#5
|
|||
|
|||
|
Thank you!
"Gord Dibben" wrote: Josie Check out Chip Pearson's site for formulas and a downloadable workbook with examples. http://www.cpearson.com/excel/FirstLast.htm Gord Dibben Excel MVP On Sun, 20 Feb 2005 12:15:02 -0800, "josie" wrote: how do I reverse an entire column of names that have the last name first, first name and then middle name or initial .....in an excel workbook? Thanks! |
|
#6
|
|||
|
|||
|
Appreciate the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "josie" wrote in message ... Thank you so much! It took awhile but I just now figured out the wizard thing and it worked. I would never have known where to start. Thanks so much! Josie "josie" wrote: how do I reverse an entire column of names that have the last name first, first name and then middle name or initial .....in an excel workbook? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i print a column containing 150 names on 1 sheet of paper . | Excel Discussion (Misc queries) | |||
| Edit a column of names | Excel Discussion (Misc queries) | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
| how can I change the a,b,c, column headers in excel to names | Excel Discussion (Misc queries) | |||
| I typed a column in reverse order, how do I flip it (upside down). | Charts and Charting in Excel | |||
Linear Mode
