View Single Post
 
Old 11-02-2016, 06:35 AM
lmvantassel lmvantassel is offline Windows 10 Office 2013
Novice
 
Join Date: Nov 2016
Posts: 2
lmvantassel is on a distinguished road
Default How to remove the last comma at the end of a table entry

I am using MergeFields to pull information from a database into a Microsoft Word table. If there is nothing in the last field, it still inserts the comma - with nothing after. I need to find a way to remove the last comma if there are no words following it. I cannot use a Replace, because there are other commas that need to stay. Here is an example:

"24 Volt D.C Flashing Light With Built-in Antenna 433Mhz, DEA+ Product Guide", Meteor electrical, meteorelectrical.com, Code: LUMY/24A, 07/28/2010,

These merges are 250+ pages long, so I would love to find a way to delete these "last" commas without going through line by line.

Thank you!
Reply With Quote