The most direct way is to use "Text To Columns", since this procedure
produces the actual data in adjoining columns, with *no* underlying
formulas, which may have to be eliminated, going forward.

Select the column of names, then:
<Data <TextToColumns, and make sure that "Delimited" is checked.
Then, <Next,
Now, check whatever your delimiter is, "Space or Comma", then,
<Finish.

You should now have your names separated into 2 or 3 columns, where you can
do whatever.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"jobby55" wrote in message
...
Is there a formula to seperate a name in one cell (last, first) and make
them
into 2 cells?