Help Centre › Building Processes
This article describes the RPA Excel functionality to merge cells.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Merge cells function allows you to merge cells.
Setting it up
To use the EXCEL Merge cells function, follow these instructions:
{{popups:rpas/add:action=excel-merge}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Merge cells function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Merge cells option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the target sheet. |
| Cell | Yes | Text | – | Cell range to merge (e.g. A1:D1). |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| Invalid range | The specified range is invalid for merging. |
Tips
- Only the value in the top-left cell of the range is kept after merging.