I agree with the wording of the question, but "will only retain" to me sounds as if the content of other cells would be lost, which isn't the case, it's just not displayed and hidden in the merged cells. We also should avoid terms like upper-left, as in a right-to-left environment
it
would be the top right cell instead.
The content remains in the hidden cells and can still be used in formulas. That is a used feature, when you will show a different content to the user than you need for calculation.
I didn't know that.. sorry, now I understand. Then what do you think about : Should the contents of all cells be concatenated and moved into the first cell ? When clicking 'No' the contents of the hidden cells will remains and can still be used in formulas. -- Maxime de Roucy Groupe LINAGORA - OSSA 80 rue Roque de Fillol 92800 PUTEAUX Tel. : 0 810 251 251
Attachment:
signature.asc
Description: This is a digitally signed message part