BeginnerText Functions
Split a full name with LEFT and FIND
Pull the first name out of a single full-name column.
LEFT · FIND
7 min15 points
Pad order numbers to five digits with TEXT
The situation
Harbor Supply's courier portal wants order references as five digits, so order 42 has to be sent as 00042. Excel drops leading zeros from numbers the moment you type them, and the team has been adding the zeros by hand on every export — and getting the count wrong on the longer numbers. The padding has to come from a formula.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order no | Courier reference | |||
| 2 | 42.00 | ||||
| 3 | 7.00 | ||||
| 4 | 1183.00 | ||||
| 5 | 9021.00 | ||||
| 6 |
Functions in this exercise
- TEXT — Formats a number as text using a format code, for padding, percentages and fixed decimals. Syntax and example
Who this is for
Recommended next
Related exercises
- BeginnerText Functions
Build a product code with CONCAT
Join a category prefix and an item number into a single SKU.
CONCAT
4 min10 points - BeginnerText Functions
Pull a state code out of a territory with RIGHT
Take the trailing two-letter state abbreviation off the end of a territory code.
RIGHT
4 min10 points - BeginnerText Functions
Split a full name with LEFT and FIND
Pull the first name out of a single full-name column.
LEFT · FIND
7 min15 points