Help Centre › Functions & Formulas
This article describes the RPA Google Workspace connector function to unmerge cells in a Google Sheet.
For a full list of available functions, please read GOOGLE WORKSPACE functions.
Description
The Unmerge cells function splits previously merged cells back into individual cells. The value from the merged cell is placed in the top-left cell; other cells become empty.
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Connector | Yes | Select | - | Select the Google Workspace connector to use |
| Spreadsheet ID | Yes | Text | - | Google Sheets spreadsheet ID |
| Sheet ID | Yes | Text | - | Numeric sheet ID |
| Range | Yes | Text | - | A1 notation range to unmerge (e.g. A1:C1) |
Errors
- Sheet not found – no sheet exists with the given ID
Tips
- If the range contains no merged cells, the operation completes without error
Related functions
- Merge cells – Merge cells together