Formating Names

[Richard Mahan]

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.

 

[Gord Dibben]

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