I should, of course, have asked what you mean by "can't seem to get to
work".
What error message did you get? If no error message, what result did you
get for what input, and what result did you expect?
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
The formula I gave works for me.
That formula was
=IF(B1+B2+B3,"Dear "&IF(B1,A1,"")&IF(B1*(B2+B3)," /
","")&IF(B2,A2,"")&IF(B2*B3," / ","")&IF(B3,A3,""),"")
but you may need to be careful if the newsgroup has split the formula at a
line wrap.
If it splits the lines at the " / " stage, there is a space, a slant, and
another space, between the quotes.
--
David Biddulph

"Sean" wrote in message
...
Thanks David, can't seem to get to work

Is this part complete =IF(B1+B2+B3,"Dear "&.....