> For the complete documentation index, see [llms.txt](https://lochiwei.gitbook.io/web/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://lochiwei.gitbook.io/web/appendix/gas/app/member/app.mergedcellvalue.md).

# app.mergedCellValue()

[GAS](/web/appendix/gas.md) ⟩ [app](/web/appendix/gas/app.md) ⟩ .mergedCellValue()

{% tabs %}
{% tab title="💾 程式" %}
⬆️ 需要： [app](/web/appendix/gas/app.md), [Broken mention](broken://pages/yBUzRclQF6ZBjZYXLBA9), [Broken mention](broken://pages/QFy78IcIft10NLqBUxn4)

```javascript
// 🔸 app.mergedCellValue(rangeName, separator='')
app.mergedCellValue = function(rangeName, separator='') {
  return app.range.byName(rangeName)
    .getValues()          // ⭐ 2D array
    .flat()               // ⭐ 1D array
    .join(separator);
};
```

{% endtab %}

{% tab title="👥 相關" %}

* [app.valueOfNamedRange()](/web/appendix/gas/app/member/app.valueofnamedrange.md) - value of a single cell.
* [app.cellValueAt()](/web/appendix/gas/app/member/app.cellvalueat.md)
  {% endtab %}

{% tab title="📘 手冊" %}

* javascript ⟩ [Array](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array) ⟩
  * .[flat()](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/flat)
  * [.join()](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/join)
    {% endtab %}
    {% endtabs %}