If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
putting symbol at end of each word
i want to put a comma at the end of each word in a column in a table. how do
i do that? |
#2
|
|||
|
|||
putting symbol at end of each word
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 Word MVP web site http://word.mvps.org "strawberryangel83" wrote in message ... i want to put a comma at the end of each word in a column in a table. how do i do that? |
Thread Tools | |
Display Modes | |
|
|