Last Name, First Name

[DMKanz]

Does anyone know if there is a function that will separate
text out of one cell.

Example Cell A1 = Lastname, Firstname

I would like Cell A1 = Lastname and Cell A2 = Firstname

Thanks in advance

DMKanz

 

[Don Guillett]

data>text to columns

 

[DMKanz]

Thanks

-----Original Message-----
data>text to columns




.