I have a contract that i need to change values in however trawling through its 24 pages every time i need to change 1 or 2 words is a pain. I have made the document in excel instead of word and created a data sheet with links to the cells that can be replaced, for example:

the contract is in the sum of £2,000 pounds.

my problem is, i would ideally like the formatting to correct itself, because other areas of the document can vary in size which causes them to either get cut off or look stupid.

is there any way to take just the '£2,000' selection in a merged cell and link it to another value on the sheet?

alternatively the only other way i can think of doing it, is to create a data sheet with all my input values in, and create a mail merge in word. I just want to avoid opening loads of programs.

Can anyone help with this?