I'm working in Excel 2016. I have the following typed into a merged cell 11/5 to 11/9/18.
I want this information (11/5 to 11/9/18) to repeat in other cells instead of typing it over multiple times. I used the formula =CELL("content",a1), however this is bringing back the result of #VALUE ...