Adding a space in text

[MB]

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

[Ardus Petus]

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

HTH
--
AP

"MB" <MB@discussions.microsoft.com> a écrit dans le message de news:
223662FD-5433-440D-959C-435F1B0858F4@microsoft.com...
> 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

[Kevin Vaughn]

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

[Gary''s Student]

=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

[Don Guillett]

you said a formula, so

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"MB" <MB@discussions.microsoft.com> wrote in message
news:223662FD-5433-440D-959C-435F1B0858F4@microsoft.com...
> 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

[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
> dguillett1@austin.rr.com
> "MB" <MB@discussions.microsoft.com> wrote in message
> news:223662FD-5433-440D-959C-435F1B0858F4@microsoft.com...
> > 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
>
>
>

[CarlosAntenna]

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

--
Carlos

"MB" <MB@discussions.microsoft.com> wrote in message
news:223662FD-5433-440D-959C-435F1B0858F4@microsoft.com...
> 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