Hi
try in B1
=SUBSTITUTE(A1,",",", ")

--
Regards
Frank Kabel
Frankfurt, Germany


Hi,

I am looking for the Excel function that will allow me to add a space
to a cell that contains the following:

A1 Cell Currently:

Johnson,Jack

Want to add a new column (Cell B1) to have the cell contents appear
as:
Johnson, Jack


Thanks Much for any help!
Andrew


---
Message posted from http://www.ExcelForum.com/