I have a formula...LEFT(D2,FIND(",",D2,1)-1)
Basically it takes Civic Memorial Field, Somwhere, NV
and gives me only Civic Memorial Field.

However when I use this field in a mail merge using word it only recognizes
the number of spaces.

Is there anyway to add a funcion on my formula to return the actual value.
If I do a copy and paste special value it works correctly in the mail merge
but w/ this method everytime I change the document I would have to recopy and
paste special again. Hopefully I haven't confused anyone too much. Thanks
in advance,

Kreiss