HW 6.2GD EXER Split Amperand

	A	B	C	D	E	F	G	H
1	NAME	SCHOOL	CITY	STATE		CHALLENGE ONE -- USE SPLIT FORMULA TO SEPARATE FIRST AND LAST NAMES INTO COLUMNS F AND G. Do just one and then magic spot fill down.
2	Amanda Abraham	St. Francis Episcopal Day School	Houston	TX	Amanda Abraham	Amanda	Abraham
3	Carrie Fowler	St. John's Parish Episcopal Day School	Tampa	FL	Carrie Fowler	Carrie	Fowler
4	Dick Peller	Northfield Mount Hermon School	Gill	MA	Dick Peller	Dick	Peller
5	Jenny Zagariello	Pingry School	Bernards	NJ	Jenny Zagariello	Jenny	Zagariello
6	Joanna Sherman	Rodoph Sholom School	New York	NY	Joanna Sherman	Joanna	Sherman
7	Rachel Delcambre	Ascension Episcopal School	Lafayette	LA	Rachel Delcambre	Rachel	Delcambre
8	Sandra Young	Ascension Episcopal School	Lafayette	LA	Sandra Young	Sandra	Young
9	COPY AND PASTE my worksheet named STEVE into a new worksheet that you will name after yourself. If you are stumped and want to see solutions, I have created a worksheet named LB with the answers. Good luck!					CHALLENGE TWO -- use the & command to generate the sentence "Amanda Abraham works in Houston in the state of TX." without the quotes of course. Don't forget the period and make sure you do just ONE and then magic spot fill down.
10			Houston	TX	Amanda Abraham	Amanda Abraham works in Houston in the state of TX
11			Tampa	FL	Carrie Fowler	Amanda Abraham works in Houston in the state of TX
12			Gill	MA	Dick Peller	Don't use this worksheet but COPY and PASTE into your own!
13			Bernards	NJ	Jenny Zagariello
14			New York	NY	Joanna Sherman
15			Lafayette	LA	Rachel Delcambre
16			Lafayette	LA	Sandra Young
17	NAME	SCHOOL	CITY	STATE	TEAM	CHALLENGE THREE -- use the MERGE feature to make your sentence span 3 columns like my instructions in yellow.
18	Amanda Abraham	St. Francis Episcopal Day School	Bernards	NJ	turquoise
19	Carrie Fowler	St. John's Parish Episcopal Day School	Gill	MA	turquoise
20	Dick Peller	Northfield Mount Hermon School	Houston	TX	purple	Don't use this worksheet but COPY and PASTE into your own!
21	Jenny Zagariello	Pingry School	Lafayette	LA	turquoise			-[
22	Joanna Sherman	Rodoph Sholom School	Lafayette	LA	purple
23	Rachel Delcambre	Ascension Episcopal School	New York	NY	green
24	Sandra Young	Ascension Episcopal School	Tampa	FL	green
25						CHALLENGE FOUR -- HIGHLIGHT JUST ROWS 18-24 in your own worksheet and SORT BY COLUMN E so that partners are next to each other.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100