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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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