Excel Function to add a space within a cell

[sportsgeek]

Hi,

I am looking for the Excel function that will allow me to add a spac
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 appea
as:
Johnson, Jack


Thanks Much for any help!
Andre

 

[Frank Kabel]

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

 

[sportsgeek]

Worked like a charm...thanks much!!!