you said a formula, so

=LEFT(D4,FIND(",",D4)) & " "&MID(D4,FIND(",",D4)+1,LEN(D4)-FIND(",",D4)+2)

--
Don Guillett
SalesAid Software

"MB" wrote in message
...
Hello experts,

A previous employee created a spreadsheet whereas in Column A are employee
names as follows:

Doe,John

Is there a formula that would add a space between the column and first
name?

Thanks so much for your help! I'm using Excel 2003.
--
MB