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
|