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
|