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
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.