On Fri, 22 May 2009 16:54:03 -0700, Scafidel wrote:

Thanks. That'll help.
--
Scafidel
Lafayette, Louisiana


Here's another thought, that might let you use a proportionally spaced font:

1. Custom format the cell to have Alignment = "Distributed"
2. Construct your two strings so that within each string, the regular <space
is replaced with the <nbsp or CHAR(160), but there remains a true <space
between the phrase that you want left justified, and the one you want
right-justified.

Given your formula, something like the following might work:

=CONCATENATE(LEFT((SUBSTITUTE($B$4," ",CHAR(160))
&IF(OR($E$3=TRUE,$F$3=TRUE),(", "&$C$6),"")),
(LEN(($B$4&IF(OR($E$3=TRUE,$F$3=TRUE),(", "&$C$6),"")))))
&("Tract"&CHAR(160) & $B$3))
--ron