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
Pull a state code out of a territory with RIGHT
The situation
Harbor Supply's CRM writes territory codes as a region name and a state joined with a hyphen, like Northeast-NY. Finance wants to group the sales report by state alone, so the two letters on the end need pulling out into their own column.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Territory | State | |||
| 2 | Northeast-NY | ||||
| 3 | Southeast-GA | ||||
| 4 | Midwest-IL | ||||
| 5 | Southwest-AZ | ||||
| 6 | Northwest-OR | ||||
| 7 |
Functions in this exercise
- RIGHT — Returns a set number of characters from the end of a text value.
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