How can I adress merged cells in excel sheet?

For example: cells A1:D1 are merged und contain the string 'test'. How can I correctly adress these cells to get the string?

I tried by adressing the first cell of merged cells but read out the first letter only.

Answer 1

[Kiran Felix Robert]

Hi Denny,

You can use the readcell function to readout the cell.

The following is an example, assuming you have merged cells A1 to D1 you can specify the range as,

M = readcell('Book1.xlsx','Range','A1:D1'); 

This will readout 4 cells with M(1) containing the required text

Or

M = readcell('Book1.xlsx','Range','A1:A1'); 

This will readout the merged cells with M containing the required text

Kiran Felix Robert

[Sergio Silva]

What if I'd like to have each merged cell filled with the same content (for example, I want M to be equal to {'text' 'text' 'text' 'text'})?

Thanks!