For your example:

In A9 enter ="Dear " &F1

With the name in F1

Note the space in ="Dear "

And try this in A9:

="Dear "&F1&" "&"and "&G1

With Mr President in F1 and Monica in G1

HTH
Regards,
Howard

"krissy" wrote in message
...
Is this possible? If so, how do I do it?