How to remove the last comma at the end of a table entry

macropod · #1 11-03-2016, 12:53 PM

In that case, you'll probably need a macro like:

Code:

Sub CommaCleanUp()
Dim Tbl As Table, Cll As Cell
Application.ScreenUpdating = False
For Each Tbl In ActiveDocument.Tables
  For Each Cll In Tbl.Range.Cells
    With Cll.Range
      If Len(.Text) > 2 Then
      Do While .Characters.Last.Previous = ","
        .Characters.Last.Previous.Delete
      Loop
      End If
    End With
  Next
Next
Application.ScreenUpdating = True
End Sub

For PC macro installation & usage instructions, see: http://www.gmayor.com/installing_macro.htm

For Mac macro installation & usage instructions, see: http://word.mvps.org/Mac/InstallMacro.html

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove auto type entry	ep2002	Excel	19	11-06-2013 08:48 AM
Trying to update a table cell with a value based on a drop down box entry	mkasem	Word VBA	2	09-29-2013 08:36 PM
Remove Paragraph numbers from Table of Co	Bu_zz2020	Word	3	08-27-2013 08:49 AM
Remove space after table in header	melliejane	Word	1	03-05-2012 04:09 PM
How to remove "Table of Figures" as we do to remove the "Table of Contents"?	Jamal NUMAN	Word	1	07-08-2011 05:40 PM