Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Concatenate First, Middle, & Last Name in Excel
Bot performs concatenation of data in an Excel file and saves string data in a new column of excel.
Top Benefits
- Result in new column provides data integrity.
- Combines data / text quickly into one column quickly .
- Handles large amount of data with no any spelling mistakes / errors in the output file.
- Quick and easy solution of data concatenate in an excel file.
Tasks
- Concatenate column data in Excel using a loop action.
In our day today Excel workbooks, the data is not as per our needs where we have to split data from one cell to individual cells or vice versa. Commonly we used to Concatenate the strings in Excel e.g. Joining First name, Middle name, and Last name, adding dates in strings to get desired data.