Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2003

Tip: Looking for answers? Try searching our database.

Using IF to suppress blank or 0 field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karen White - 07 Oct 2003 16:46 GMT
I've been trying, unsuccessfully, to use the IF statement
to suppress a blank field from an excel spreadsheet. It
keeps putting a 0 in.  How exactly do I get this to ignore
the excel field if it is empty?

Really need some help - please

Karen
Peter Jamieson - 08 Oct 2003 07:50 GMT
Unfortunately, by the time the data reaches Word it already has "0" in it,
not "blank", so the only way to suppress it in Word would be to use

{ IF { MERGEFIELD myfield } = 0 "" "{ MERGEFIELD myfield }" }

and that can only work if a zero /always/ means "it's blank".

Otherwise, you will need to change the column formatting in Excel (e.g. to
text) and reconnect Word to Excel (and even that may not work), or change
the way Word connects to Excel - in Word 2002, check Word
Tools|Options|General|Confirm conversions at open, go through the connection
process again, and select the DDE method when prompted.
--
Peter Jamieson
MS Word MVP

> I've been trying, unsuccessfully, to use the IF statement
> to suppress a blank field from an excel spreadsheet. It
[quoted text clipped - 4 lines]
>
> Karen
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.