Skip to content
NewAI dashboards.See how →
Open MammothTry free
Workflow · Clean · Opening soon

Combine first and last name

Turn separate first name and last name columns into one full name column. Trim extra spaces first, then join the names and keep each employee’s department.

Early access opens shortly. Check back soon.

Book a demo
Someone typed

“from the employee roster, trim first and last names, join them into full name, and show every employee’s full name plus department”

The agent read it as

From the Employee roster, trim first and last names, join them into full name, and show every employee’s full name plus department.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Employee roster
    CSV export · 15 rows
  2. Step
    Join trimmed names
    Step 1
  3. Result
    Employee Full Names
    15 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 15 rows came out.

What you get back

The result of that run, the rows to look at first.

Employee Full NamesSample data15 rows
Full nameDepartment
Avery ChenSales
Mina PatelMarketing
Jonah ReedFinance
Elena TorresOperations
Caleb NguyenSupport
Priya ShahProduct
Lucas BrooksEngineering
Nina KellerHR
Omar HaddadSales
Sofia MartinezCustomer Success
Ethan ColeIT
Ruby FosterLegal
15 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you combine first and last name in Excel?

Export your roster from Excel as a file, then upload it to Mammoth. Trim the first and last name values, join them into one full name field, and keep the department in the same row. The result is a table with each employee’s full name and department.

How it works

How to use the Employee Full Names workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Employee Full Names: questions

What export should I use from Excel?
Use a spreadsheet export of your roster, with first name, last name, and department in separate columns.
What happens to rows that do not match the rules?
Rows that do not match stay out of the result for that step, so you can review them and adjust the rules if needed.
How do I change the name rules?
Edit the step in words, for example, trim both name columns first, then join them with a space into a full name column.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Book a demo

Workflows like this

Remove duplicate rows, catch invoices paid twice, match messy names to a master list, standardise spellings and turn wide tables long.

All cleaning templates →

Keep reading

Read nextAll workflowsDescribe yours, or start from one the agent already built.Take a lookProductData EngineConnected sources, cleaning and scheduled refresh.Take a lookConnectorsConnectorsBring the data in from the tools you already use.Take a look