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!

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" <josie@discussions.microsoft.com> wrote in message
news:27BDE187-B20A-4A6C-A72C-9807148F35AD@microsoft.com...
> 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!

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!

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" <josie@discussions.microsoft.com>
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!

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" <josie@discussions.microsoft.com>
> 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!
>
>

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"josie" <josie@discussions.microsoft.com> wrote in message
news:93A37DDC-93B5-4043-AB0C-FD455F42BE42@microsoft.com...
> 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!