Changing text appearance
 

If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as ", how would I go about doing
that? I basically have a column of data (first name and last names) I would
like to format in that manner.

Thanks in advance for any advice.

Changing text appearance
 

Try something like this:

With
A1: Jane Doe
B1: =SUBSTITUTE(A1," "

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Max Prophet" wrote:

If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as ", how would I go about doing
that? I basically have a column of data (first name and last names) I would
like to format in that manner.

Thanks in advance for any advice.

Changing text appearance
 

Like a charm! Thanks.

"Ron Coderre" wrote:

Try something like this:

With
A1: Jane Doe
B1: =SUBSTITUTE(A1," "

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Max Prophet" wrote:

If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as ", how would I go about doing
that? I basically have a column of data (first name and last names) I would
like to format in that manner.

Thanks in advance for any advice.

Changing text appearance
 

=LOWER(SUBSTITUTE(A1," "


"Max Prophet" wrote:

If cell A1 contains the text "Jane Doe", and I would like the the adjoining
cell to display as ", how would I go about doing
that? I basically have a column of data (first name and last names) I would
like to format in that manner.

Thanks in advance for any advice.