Hello

I haven't used excel for over ten years and have been asked to amend a database of names and addresses for somebody and then sort them so he can do mail outs.

Sometimes eg column a) will be Mr Smith, so letter will say Dear Mr Smith. Pips.
But sometimes column a) will be The Marketing Manager. This is great for the address label, but I want to say Dear Future Exhibitor in the letter. Do you know how I do this please?

thanks,

Paula