See

http://www.cpearson.com/excel/FirstLast.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Magic" wrote in message
...
Joe Brown is the text in a cell. Is there a worksheet function that I can
turn this into Brown, Joe in another cell.