How to Retrieve the Contents of Merged Cells Using Custom Functions

[wangizchao]

May I ask how to use a custom function to retrieve the contents of merged cells? Assuming that A1:A2 contains merged cells with the value 'value', how can I use a function in cell B1 to retrieve the value in A1:A2?

[jingwood]

I'm not sure if I understand your question correctly. You can just retrieve the value from the A1 cell.