Link Merged cells

[Memar]

Can I link data from a merged cells to single cell and Can I link dates from two different merged cells to one cell.


Example I - data 12/12/2018 saved in the merged cell A1,A2 and A3. want to link the data in cell E1- 12/12/2018

Example ii - Data 1/1/2019 saved in the merge cell B1,B2 and B3
Date 12/31/2019 saved in the merge cell C1,C2 and C3

I want to save a data in a single cell - F1 - 1/1/2019 - 12/31/2019

Thanks for your help.

 

[arthurbr]

Merged cells are one of Excel's worst features. Try to do without them

 

[6StringJazzer]

I agree with arthurbr that merged cells are not a good practice.

But since you asked, when you link to a merged cell the data is actually stored in the top-left cell of the merged block. So in your first example, in cell E1 you would use

=A1

This is the result you will get if you go to E1, type the = sign, then click on the merged cells to allow Excel to complete your formula.

In your second example, you want to build a string using data from two other cells. In F1:

=TEXT(B1,"m/d/yyyy") & " - " & TEXT(C1,"m/d/yyyy")