Use the menu option Data:Test To Columns to parse the one field into two fields


Good Luck

Stewart

"jobby" wrote:

I have a name in a cell, last name first then a comma then first name, and I
want to seperate them into two cells. I know there is a formula to do that,
but I don't know what it is, can anyone help me?