=LEFT(A1,FIND(",",A1,1)) & " " & RIGHT(A1,LEN(A1)-FIND(",",A1,1))
--
Gary''s Student


"MB" wrote:

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