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

[Guest]

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

 

[Guest]

Try something like this:

=E3&","

Does that help?

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

XL2002, WinXP-Pro

 

[Guest]

Maybe

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

 

[Guest]

Works great. Thanks.

Try something like this:

=E3&","

Does that help?

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

XL2002, WinXP-Pro

 

[Guest]

Worked great. Thanks.

Maybe

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