Excel Function to add a space within a cell
 

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

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

Excel Function to add a space within a cell
 

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/

Excel Function to add a space within a cell
 

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

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