Try something like this:

With
A1: Jane Doe
B1: =SUBSTITUTE(A1," "

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Max Prophet" wrote:

If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as ", how would I go about doing
that? I basically have a column of data (first name and last names) I would
like to format in that manner.

Thanks in advance for any advice.