ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBWBXBYBZCACBCCCDCECFCG
1
Order Summary - blogStudent NameMethodStudent Name 1Student Name 2Student Name 3Student Name 4Student Name 5Main FormulaComments
2
ITEM
QTY
UNIT PRICE
SUBTOTAL


Product Three
SQ0000003
Student's Name:
Maxine Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
6
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
$00.00
$00.00
Product Three
SQ0000003
Student's Name:
Maxwell Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
10
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
$00.00
$00.00
Product Three
SQ0000003
Student's Name:
Malphie Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
13
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
$00.00
$00.00



Item Subtotal
Discount Savings
Tax
TOTAL

$000.00
βˆ’$0.00
$0.00
$000.00

Discounts

PROMO CODE
DESCRIPTION
DISCOUNT

3KIDS
Sibling Discount Code (3)
$0.00		Maxine CarlsenManual Entry of First FormulaMaxine CarlsenMaxwell CarlsenMalphie Carlsen(?:[^πŸ”΄]+πŸ”΄){2}\n(.+)([^πŸ”΄]+)(?:πŸ”΄|$)
3
Maxine CarlsenManual Entry of Second FormulaMaxine CarlsenMaxwell CarlsenMalphie Carlsen"[^πŸ”΄]+πŸ”΄\n(.+)([^πŸ”΄]+?)" <- Add one additional instance of "+πŸ”΄\n(.+)([^πŸ”΄]" for each column
4
Maxine CarlsenAutomatic Entry of First Formula#ERROR!??????I have no idea what I'm doing here, or even if it is possible.
5
Maxine CarlsenAutomatic Entry of Second Formula, Concrete NumberMaxine Carlsen Maxwell Carlsen Malphie Carlsen
"[^πŸ”΄]+πŸ”΄\n(.+)[^πŸ”΄]+πŸ”΄\n(.+)[^πŸ”΄]+πŸ”΄\n(.+)([^πŸ”΄]+?)"This works great if I know exactly how many data points there are. But if I don't...
6
Maxine CarlsenAutomatic Entry of Second Formula, Variable Number#REF!"[^πŸ”΄]+πŸ”΄\n(.+)[^πŸ”΄]+πŸ”΄\n(.+)[^πŸ”΄](?:+πŸ”΄\n(.+)([^πŸ”΄])?+?)"I've been trying to wrap instances of "+πŸ”΄\n(.+)([^πŸ”΄]" with "(?: )?" but have had no luck so far.
7
Maxine CarlsenMaxine Carlsen Maxwell Carlsen Malphie Carlsen #VALUE!
8
Maxine Carlsen#VALUE!
9
Maxine CarlsenMaxine CarlsenMaxwell CarlsenMalphie CarlsenStudent(?:'s)? Name(?:\(s\))?:
10
#N/A(.*)\nSQ\d+
"(?s:.+?Student\'s Name:\s*(.+?)\s*Parent.+?(?:Product Three|$))",
"$1"&char(254)
torow(split(
regexreplace(A2,
"(?s:.+?Student\'s Name:\s*(.+?)\s*Parent.+?(?:Product Three|$))",
"$1"&char(254)
), char(254)
),true)
11
Product Three#N/A
ITEM
QTY
UNIT PRICE
ΓΎProduct Three
SQ0000003
Student's Name:
Maxine Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
6
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
ΓΎProduct Three
SQ0000003
Student's Name:
Maxwell Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
10
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
ΓΎProduct Three
SQ0000003
Student's Name:
Malphie Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
13
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
ΓΎItem Subtotal
Discount Savings
Tax
TOTAL

$000.00
βˆ’ΓΎ$000.00

Discounts

PROMO CODE
DESCRIPTION
DISCOUNT

3KIDS
Sibling Discount Code (3)
$0.00
#N/AITEM
QTY
UNIT PRICE
Product Three
SQ0000003
Student's Name:
Maxine Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
6
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
Product Three
SQ0000003
Student's Name:
Maxwell Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
10
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
Product Three
SQ0000003
Student's Name:
Malphie Carlsen
Parent/Guardian's Name:
Magnus Carlsen
Age:
13
Allergies/Concerns:
None
Emergency Contact Number:
(111) 111-1113
1
Item Subtotal
Discount Savings
Tax
TOTAL

$000.00
βˆ’		$000.00

Discounts

PROMO CODE
DESCRIPTION
DISCOUNT

3KIDS
Sibling Discount Code (3)
$0.00
12
 #N/A
13
Product Three Product Three Product Three
14