Formating Names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Mahan - 09 Jul 2006 17:14 GMT

I have an example where the First and Last Name of my contacts are in a
single column. I would like the first and last name in separate columns
ie: John in Column A and Brown in column B any help would be
appreciated.

Reply to this Message

Gord Dibben - 09 Jul 2006 17:27 GMT

Richard

It may as simple as Data>Text to Columns>De-limited by>Space.

Then again, if you have cells with more than just two name, you may require
something else.

I would recommend Chip Pearson's site.

http://www.cpearson.com/excel/FirstLast.htm

Gord Dibben MS Excel MVP

>I have an example where the First and Last Name of my contacts are in a
>single column. I would like the first and last name in separate columns
>ie: John in Column A and Brown in column B any help would be
>appreciated.

Reply to this Message