Add a comma at the end of a word in a cell
 

I have cities in a column and I would like to add a comma at the end inside
the cell. how do I do that?

Add a comma at the end of a word in a cell
 

Say your cities are in column A. In a helper column, enter =A1 & "," and
copy down. Then copy the helper column and paste/special value back into
your original column.
--
Gary's Student


"Angela" wrote:

I have cities in a column and I would like to add a comma at the end inside
the cell. how do I do that?

Add a comma at the end of a word in a cell
 

I'm assuming you want a formula for this.
With the city in A1:

=A1 & ", "

The formula above also includes a space after the comma with assumption that
you will be adding the state. If your state is in B1, then the formula
would be as follows.
=A1 & ", " & B1

And with the zip code in C1:
=A1 & ", " & B1 & " " & C1

Regards,
Paul

"Angela" wrote in message
...
I have cities in a column and I would like to add a comma at the end inside
the cell. how do I do that?

Add a comma at the end of a word in a cell
 

That worked great! Thanks so much Gary!

"Gary''s Student" wrote:

Say your cities are in column A. In a helper column, enter =A1 & "," and
copy down. Then copy the helper column and paste/special value back into
your original column.
--
Gary's Student


"Angela" wrote:

I have cities in a column and I would like to add a comma at the end inside
the cell. how do I do that?