Workflow · Clean · Opening soon

Extract numbers from text

Pull the number out of each description into its own column. Keep the other columns as they are in your Excel export.

Book a demo

Someone typed

“pull the number out of each description into its own column, and keep the other columns as they are”

The agent read it as

Pull the number out of each description into its own column, and keep the other columns as they are in Excel export.

What the agent built

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

File

Excel export

CSV export · 20 rows

Step

Extract the number

Step 1

Result

Description Number

20 rows

Schedule

Runs when you say

Proposed

File
Excel export
CSV export · 20 rows
Step
Extract the number
Step 1
Result
Description Number
20 rows
Schedule
Runs when you say
Proposed

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

Download Excel export sample (20 rows)Excel: File > Save As > CSV (one worksheet with the data range)

What you get back

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

Description NumberSample data20 rows

Row ID	Number	Owner	Description
r_001	12	Maya Chen	Ordered 12 chairs for the lobby
r_002	45.50	Noah Patel	Refund of 45.50 for damaged box
r_003	3	Ava Brooks	Received 3 replacement cables
r_004	18	Ethan Ward	Booked 18 seats for the training room
r_005	250	Lina Gomez	Paid 250 for annual license
r_006	7	Owen Li	Installed 7 new monitors
r_007	64	Sofia Reed	Shipped 64 brochures to the event
r_008	9	Caleb Stone	Requested 9 extra badges
r_009	120	Nina Hall	Collected 120 from petty cash
r_010	15	Jack Miller	Ordered 15 pens for the team
r_011	2	Priya Shah	Processed 2 vendor credits
r_012	24	Mason Clark	Reserved 24 parking spots

20 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you extract numbers from text in Excel?

Export your Excel file, then use a workflow step that pulls the number from each description into its own column. The other columns stay the same. You can then export the updated sheet with the new number column added.

How it works

How to use the Description Number workflow

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.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Description Number: questions

Which Excel file should you export?

Export the sheet that has the text column you want to clean and the other columns you want to keep. The workflow uses that exported file as its input.

What happens to rows that do not contain a number?

Those rows stay in the file. The number column is left blank for them unless you set a different rule.

How do you change the rule in words?

Edit the step description to say what text to pull out and where to put it. For example, say to extract the number from the description column into a new number column.