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

In an empty column, enter:
=SUBSTITUTE(A1,",",", ")

HTH
--
AP

"MB" a écrit dans le message de news:
...
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

This seems to work:

=LEFT(A1,FIND(",",A1)) & " " & RIGHT(A1, LEN(A1)-FIND(",",A1))

--
Kevin Vaughn


"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

=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

you said a formula, so

=LEFT(D4,FIND(",",D4)) & " "&MID(D4,FIND(",",D4)+1,LEN(D4)-FIND(",",D4)+2)

--
Don Guillett
SalesAid Software

"MB" wrote in message
...
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

WOW! You are all so wonderful! Thank you!!
--
MB


"Don Guillett" wrote:

you said a formula, so

=LEFT(D4,FIND(",",D4)) & " "&MID(D4,FIND(",",D4)+1,LEN(D4)-FIND(",",D4)+2)

--
Don Guillett
SalesAid Software

"MB" wrote in message
...
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

If you want to insert the space and leave the text in the same column:
Select the column.
Editreplacefind , replace with ,<space

--
Carlos

"MB" wrote in message
...
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