Free Support Forum -

HOw to get data from merged Cells

I have a file where cells are merged vertically.

How can i read this data. I attached a table.

or weather this will be consider as one Cell or 3 Cells.


Well, A Merged Cell is basically a single cell that is created by combining two or more selected cells.The cell reference for a merged cell is the upper-left cell in the original selected range. So, you will get data from the merged cell similar to what you get data from other cells, see the topic for reference: