Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# How to concatenate four Word Merge Fields in a Formula?

Posted on 2013-06-21
Medium Priority
3,371 Views
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?

0
Question by:MitchellVII
1 Comment

LVL 76

Accepted Solution

GrahamSkan earned 2000 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

Question has a verified solution.

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

Do you ever need to create a 20 page Word document for some testing purpose? Are you tired of copying & pasting old boring "lorem ipsum" text over and over again, increasing font size and line space in order to make the document 20+ pages long? Look…
Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
###### Suggested Courses
Course of the Month8 days, 13 hours left to enroll