Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-30-2014, 02:43 AM
macropod's Avatar
macropod macropod is offline Suppress comma in "city , stat zip" line when blank Windows 7 32bit Suppress comma in "city , stat zip" line when blank Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,526
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

For the comma:
Delete both the comma and the space following the «city» field.
Select the «city» field and press Shift-F9. You should see { MERGEFIELD city }. Change this to { MERGEFIELD city \f ", "} and press F9 to update.

For the slash:
Delete the slash and the spaces either side of it.
Where the slash was, press Ctrl-F9 to create another field, which will look like { }
Insert another pair of «Home_TX» and «cell_TX» fields between the braces, thus:
{ «Home_TX» «cell_TX» }
Select the new «cell_TX» field and press Ctrl-F9 to create another field. You should now have:
«Home_TX»{ «Home_TX» {«cell_TX»} }«cell_TX»
Edit the fields you've created so you get {IF«Home_TX» <> "" {IF«cell_TX» <> "" " / "}}
Press F9 to update.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Suppress comma in &quot;city , stat zip&quot; line when blank Word is displaying my "compatible" docs as blank! RobDuBois Word 3 01-20-2013 04:40 PM
Suppress comma in &quot;city , stat zip&quot; line when blank How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? Learner7 Excel 1 04-25-2011 04:39 AM
"Inserting" 11x17 blank sheet into report mcjohn Word 2 01-06-2010 09:14 AM
"Intentionally left in Blank" Pages Manolo Word 2 04-30-2009 04:20 AM
Suppress comma in &quot;city , stat zip&quot; line when blank Suppress "do you want to save?" dialog on close rnstewart Excel 2 12-28-2005 04:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:07 PM.


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