Solved

How to concatenate four Word Merge Fields in a Formula?

Posted on 2013-06-21
1
3,130 Views
Last Modified: 2013-06-21
Hi,

I'm working in Word 2007.  If want to create an "IF" equation where I evaluate whether the concatenation of four Merge Fields = "".

Fields are:

{ MERGEFIELD "Horizontal1" }
{ MERGEFIELD "Vertical1" }
{ MERGEFIELD "Hardware1" }
{ MERGEFIELD "Code1" }

Equation should look something like:

{ IF (concatenated fields...)="" ">" "{ MERGEFIELD "Horizontal1" }"}

Any ideas?

Thanks in advance :-)
0
Comment
Question by:MitchellVII
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 39265768
Hi Bill,

There is a Quote field, but double quotes should do the same job.

{ IF "{ MERGEFIELD "Horizontal1" }{ MERGEFIELD "Vertical1" }{ MERGEFIELD "Hardware1" }{ MERGEFIELD "Code1" }"="" ">" "{ MERGEFIELD "Horizontal1" }"}
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing. A Range prope…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question