How to add characters to all existing values in a given column
 

I have a column that has existing values in most rows. I want to add a comma
to the end of every non-empty cell in that column. For e.g., I want to change

"Thompson"

to

"Thompson,"

Can I use the SUBSTITUTE or REPLACE functions for this? I tried something
like:

=SUBSTITUTE(E3, E3, E3 & ",")

But that don't work...

Thanks

How to add characters to all existing values in a given column
 

Try something like this:

=E3&","

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Danny" wrote:

I have a column that has existing values in most rows. I want to add a comma
to the end of every non-empty cell in that column. For e.g., I want to change

"Thompson"

to

"Thompson,"

Can I use the SUBSTITUTE or REPLACE functions for this? I tried something
like:

=SUBSTITUTE(E3, E3, E3 & ",")

But that don't work...

Thanks

How to add characters to all existing values in a given column
 

Maybe

=if(len(e3)0,e3&",","")

"Danny" wrote:

I have a column that has existing values in most rows. I want to add a comma
to the end of every non-empty cell in that column. For e.g., I want to change

"Thompson"

to

"Thompson,"

Can I use the SUBSTITUTE or REPLACE functions for this? I tried something
like:

=SUBSTITUTE(E3, E3, E3 & ",")

But that don't work...

Thanks

How to add characters to all existing values in a given column
 

Works great. Thanks.

"Ron Coderre" wrote:

Try something like this:

=E3&","

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Danny" wrote:

I have a column that has existing values in most rows. I want to add a comma
to the end of every non-empty cell in that column. For e.g., I want to change

"Thompson"

to

"Thompson,"

Can I use the SUBSTITUTE or REPLACE functions for this? I tried something
like:

=SUBSTITUTE(E3, E3, E3 & ",")

But that don't work...

Thanks

How to add characters to all existing values in a given column
 

Worked great. Thanks.

"Duke Carey" wrote:

Maybe

=if(len(e3)0,e3&",","")

"Danny" wrote:

I have a column that has existing values in most rows. I want to add a comma
to the end of every non-empty cell in that column. For e.g., I want to change

"Thompson"

to

"Thompson,"

Can I use the SUBSTITUTE or REPLACE functions for this? I tried something
like:

=SUBSTITUTE(E3, E3, E3 & ",")

But that don't work...

Thanks