«Sal» «FirstName» «MI» «LastName» «Suffix» I have excess spacing between the
middle initial and last name when the person does not have a middle initial.

Use an If...Then...Else field that returns the MI and the LastName if the MI
exists or just returns the LastName if it does not.

{ IF { MERGEFIELD "MI" } "" { MERGEFIELD "MI"} { MERGEFIELD "LastName" }
{ MERGEFIELD "LastName" } }

Use a non-breaking space between { MERGEFIELD "MI"} and { MERGEFIELD
"LastName" } so that it gets treated as the result for the "true" condition.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Gene" wrote in message
...
«Sal» «FirstName» «MI» «LastName» «Suffix» I have excess spacing between
the
middle initial and last name when the person does not have a middle
initial.

Doug

Given the space is that going to work without the speech marks?

{ IF { MERGEFIELD MI } "" "{ MERGEFIELD MI} { MERGEFIELD LastName }" "{
MERGEFIELD LastName }" }

might be better in the circumstances?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Doug Robbins wrote:
Use an If...Then...Else field that returns the MI and the LastName if
the MI exists or just returns the LastName if it does not.

{ IF { MERGEFIELD "MI" } "" { MERGEFIELD "MI"} { MERGEFIELD
"LastName" } { MERGEFIELD "LastName" } }

Use a non-breaking space between { MERGEFIELD "MI"} and { MERGEFIELD
"LastName" } so that it gets treated as the result for the "true"
condition.


Hope this helps,
Doug Robbins - Word MVP
"Gene" wrote in message
...
«Sal» «FirstName» «MI» «LastName» «Suffix» I have excess spacing
between the
middle initial and last name when the person does not have a middle
initial.

Thanks, Graham. I thought that the non-breaking space might do the trick,
but testing it now, I find that it doesn't.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Graham Mayor" wrote in message
...
Doug

Given the space is that going to work without the speech marks?

{ IF { MERGEFIELD MI } "" "{ MERGEFIELD MI} { MERGEFIELD LastName }" "{
MERGEFIELD LastName }" }

might be better in the circumstances?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Doug Robbins wrote:
Use an If...Then...Else field that returns the MI and the LastName if
the MI exists or just returns the LastName if it does not.

{ IF { MERGEFIELD "MI" } "" { MERGEFIELD "MI"} { MERGEFIELD
"LastName" } { MERGEFIELD "LastName" } }

Use a non-breaking space between { MERGEFIELD "MI"} and { MERGEFIELD
"LastName" } so that it gets treated as the result for the "true"
condition.


Hope this helps,
Doug Robbins - Word MVP
"Gene" wrote in message
...
«Sal» «FirstName» «MI» «LastName» «Suffix» I have excess spacing
between the
middle initial and last name when the person does not have a middle
initial.