Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-02-2016, 03:58 PM
macropod's Avatar
macropod macropod is offline How to remove the last comma at the end of a table entry Windows 7 64bit How to remove the last comma at the end of a table entry Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by lmvantassel View Post
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.
Assuming each line is terminated by a paragraph break, you could use Find/Replace, with:
Find = ,^p
Replace = ^p

Better still, since this is for a mailmerge, you should consider using the mergefield \b switch in the last mergefield in the mailmerge main document and omitting the preceding comma. For example:
{MERGEFIELD Item \b ", "}
where 'Item' is the mergefield name.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



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 03:41 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