Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-02-2016, 06:35 AM
lmvantassel lmvantassel is offline How to remove the last comma at the end of a table entry Windows 10 How to remove the last comma at the end of a table entry Office 2013
Novice
How to remove the last comma at the end of a table entry
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove auto type entry ep2002 Excel 19 11-06-2013 08:48 AM
How to remove the last comma at the end of a table entry 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
How to remove the last comma at the end of a table entry Remove space after table in header melliejane Word 1 03-05-2012 04:09 PM
How to remove the last comma at the end of a table entry 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft