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

D

Danny

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
 
R

Ron Coderre

Try something like this:

=E3&","

Does that help?

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

XL2002, WinXP-Pro
 
Top