Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number in cell convert in word | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
Can not see all of a pasted paragraph from Word in a cell. | Excel Discussion (Misc queries) |