Split and rebuild text by showing Excel one worked example, and recognise when Flash Fill is the wrong tool.
Ridgeline's sales export has the rep's full name in one column. Marketing wants first and last separately, and IT wants email addresses. You could write three text formulas. You could also type one example and press one key.
0 XP
Step 1 of 6 · 1 point
You have typed one example of the pattern you want in the column beside your data. Press the shortcut that fills the rest.
A
B
C
D
E
F
G
H
I
J
1
OrderID
Date
Branch
Rep
Category
Product
Qty
UnitPrice
Discount
LineTotal
2
4001
2026-01-05
Fairview
Priya Raghavan
Electrical
Romex 12-2 250ft
4
148.00
0.1
532.80
3
4002
2026-01-05
Fairview
Priya Raghavan
Electrical
Romex 12-2 250ft
5
148.00
0
740.00
4
4003
2026-01-06
Northgate
Marcus Ellery
Paint
Wood primer, 1gal
2
46.75
0.05
88.83
5
4004
2026-01-07
Northgate
Marcus Ellery
Plumbing
Ball valve 1/2in
1
9.25
0.05
8.79
6
4005
2026-01-07
Brookside
Danielle Okafor
Plumbing
Copper pipe 1/2in 10ft
1
31.40
0
31.40
7
4006
2026-01-08
Brookside
Danielle Okafor
Plumbing
Copper pipe 1/2in 10ft
1
31.40
0
31.40
8
4007
2026-01-08
Brookside
Danielle Okafor
Paint
Interior latex paint, 5gal
3
138.00
0.05
393.30
9
4008
2026-01-08
Brookside
Danielle Okafor
Tools
Cordless drill 18V
5
209.00
0.1
940.50
10
4009
2026-01-09
Fairview
Priya Raghavan
Plumbing
Ball valve 1/2in
3
9.25
0
27.75
11
4010
2026-01-09
Northgate
Marcus Ellery
Paint
Roller and tray set
6
14.20
0
85.20
12
4011
2026-01-09
Brookside
Danielle Okafor
Plumbing
Water heater element 4500W
6
24.10
0
144.60
13
4012
2026-01-10
Northgate
Marcus Ellery
Tools
Cordless drill 18V
1
209.00
0
209.00
14
4013
2026-01-10
Northgate
Marcus Ellery
Plumbing
Copper pipe 1/2in 10ft
4
31.40
0.05
119.32
Rows 1 to 14 of 315
Hold the modifiers, then press the last key. We read it straight from your keyboard.