Data Sheets & Merged Cells

**tatkinsun86** · 03-09-2010, 05:52 PM

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?

**martindwilson** · 03-09-2010, 06:16 PM

don't merge cells use centre across selection instead.
post an example workbook

**tatkinsun86** · 03-10-2010, 06:37 AM

If i centre they all look a bit silly.

Here is a example i just wrote. Sorry im not too good at explaining what i need to do.

**martindwilson** · 03-12-2010, 08:54 PM

="Please supply and install the "&C9&" all in your quotation reference "&C10&" for the total lump sum of "&TEXT(C11,"£#,##0.00")
centered across selection
or just format cell to wrap text