how do I create a formula to seperate name into two cells (last, .
 

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

Hi Jobby,

You could use tht Text To Columns feature.

With the name cells selected, try:

Data | Text To Columns | Delimited | Next | Select appropriate
delimiter |
Next | Next | Finish

---
Regards,
Norman



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

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?