Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
macro to add a comma
I need to add a comma at the end of every cell entry in one column and am
not having any success doing it. It's gotta be easy for someone. Help. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
macro to add a comma
BrianMultilLanguage wrote:
I need to add a comma at the end of every cell entry in one column and am not having any success doing it. It's gotta be easy for someone. Help. If the column that you want to add a comma is A, try to put the formula in column B =A1 & "," Copy the formula to others cells in the same column (B) -- Rodrigo Ferreira Regards from Brazil |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
macro to add a comma
Rodrigo,
That will add commas to empty cells. I suggest highlighting the range to be chabged and running: Sub AddComma() For Each cell In Selection If cell.Value < "" Then cell.Value = cell.Value & "," End If Next cell End Sub -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Rodrigo Ferreira" wrote in message ... BrianMultilLanguage wrote: I need to add a comma at the end of every cell entry in one column and am not having any success doing it. It's gotta be easy for someone. Help. If the column that you want to add a comma is A, try to put the formula in column B =A1 & "," Copy the formula to others cells in the same column (B) -- Rodrigo Ferreira Regards from Brazil |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
macro to add a comma
Terriffic.
Thanks. Worked after I selected the range. "Sandy Mann" wrote in message ... Rodrigo, That will add commas to empty cells. I suggest highlighting the range to be chabged and running: Sub AddComma() For Each cell In Selection If cell.Value < "" Then cell.Value = cell.Value & "," End If Next cell End Sub -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Rodrigo Ferreira" wrote in message ... BrianMultilLanguage wrote: I need to add a comma at the end of every cell entry in one column and am not having any success doing it. It's gotta be easy for someone. Help. If the column that you want to add a comma is A, try to put the formula in column B =A1 & "," Copy the formula to others cells in the same column (B) -- Rodrigo Ferreira Regards from Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dot and comma | Excel Discussion (Misc queries) | |||
New row after every comma | Excel Discussion (Misc queries) | |||
Comma delimiter | Excel Worksheet Functions | |||
Comma | Excel Worksheet Functions | |||
Excel How do I create a comma delineated xls file to a comma delineated. | Excel Discussion (Misc queries) |