putting symbol at end of each word

  • Thread starter Thread starter strawberryangel83
  • Start date Start date
S

strawberryangel83

i want to put a comma at the end of each word in a column in a table. how do
i do that?
 
Assuming there is only one word in each cell in the column, the following
macro will put a comma after each word in the column containing the cursor.
Empty cells are ignored

Dim oCell As Cell
With Selection.Columns(1)
For Each oCell In .Cells
If Len(oCell.Range) > 2 Then
oCell.Range.InsertAfter Chr(44)
End If
Next oCell
End With

http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top