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?