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
Find where a word starts with SEARCH
The situation
Harbor Supply's product descriptions come from a dozen suppliers and none of them capitalise consistently — Pallet, pallet and PALLET all appear. Merchandising wants to know where the word starts in each description so they can trim the text around it.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Description | Position | |||
| 2 | Heavy duty Pallet, 48x40 | ||||
| 3 | Euro pallet, four-way entry | ||||
| 4 | Export PALLET, heat treated | ||||
| 5 | Nestable pallet, plastic | ||||
| 6 |
Functions in this exercise
- SEARCH — Like FIND, but ignores case and accepts wildcards.
Who this is for
Recommended next
Related exercises
- 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 - IntermediateText Functions
Pull the year out of an order code with MID
Extract characters from the middle of a text value.
MID
7 min25 points - BeginnerText Functions
Build a mailing address with TEXTJOIN
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
6 min15 points