Including text in formula

[golfnut111]

Under week 1 I have team 1 vs. team 7. Below I'm trying to put that into text. I don't know what I'm doing wrong. I want the formula to say Bohn & Mills Vs. Ginderske & Maxwell. The text doesn't show up though.

Schedule maker.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
2		Teams			Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
3	1	Bohn & Mills			1-7	1-12	1-3	1-8	1-9	1-4	1-2	1-6	1-10	Fun night
4	2	Abbate & Hamlin			2-8	2-9	2-11	2-5	2-6	2-3	8-10	2-7	2-4
5	3	Killinger & Dryer			3-9	7-8	4-5	3-7	3-11	5-10	12-3	11-10	3-8
6	4	Dyer & Dunn			4-10	3-5	6-8	4-12	4-8	6-9	11-9	12-9	5-9
7	5	Vayer & Dryer			5-11	11-4	7-9	6-11	5-12	7-11	5-7	3-4	6-7
8	6	Grady & Potter			6-12	6-10	10-12	10-9	7-10	8-12	4-6	5-8	11-12
9	7	Ginderske & Maxwell
10	8	Ashmore &			Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20
11	9	Hanson & Roberts			1-5	1-11	1-7	1-12	1-3	1-8	1-9	1-4	1-2	Fun night
12	10	Suitor & Richardson			2-10	2-12	2-8	2-9	2-11	2-5	2-6	2-3	8-10
13	11	Waite & Dryer			11-8	3-10	3-9	7-8	4-5	3-7	3-11	5-10	12-3
14	12	Hamilton & Laubscher			12-7	4-7	4-10	3-5	6-8	4-12	4-8	6-9	11-9
15					6-3	5-6	5-11	11-4	7-9	6-11	5-12	7-11	5-7
16					9-4	8-9	6-12	6-10	10-12	10-9	7-10	8-12	4-6
17
18		Week 1
19		=B3& " Vs. " &B9
20
21
22
23
24
25
26
Sheet1

Schedule maker.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
2		Teams			Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10
3	1	Bohn & Mills			1-7	1-12	1-3	1-8	1-9	1-4	1-2	1-6	1-10	Fun night
4	2	Abbate & Hamlin			2-8	2-9	2-11	2-5	2-6	2-3	8-10	2-7	2-4
5	3	Killinger & Dryer			3-9	7-8	4-5	3-7	3-11	5-10	12-3	11-10	3-8
6	4	Dyer & Dunn			4-10	3-5	6-8	4-12	4-8	6-9	11-9	12-9	5-9
7	5	Vayer & Dryer			5-11	11-4	7-9	6-11	5-12	7-11	5-7	3-4	6-7
8	6	Grady & Potter			6-12	6-10	10-12	10-9	7-10	8-12	4-6	5-8	11-12
9	7	Ginderske & Maxwell
10	8	Ashmore &			Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20
11	9	Hanson & Roberts			1-5	1-11	1-7	1-12	1-3	1-8	1-9	1-4	1-2	Fun night
12	10	Suitor & Richardson			2-10	2-12	2-8	2-9	2-11	2-5	2-6	2-3	8-10
13	11	Waite & Dryer			11-8	3-10	3-9	7-8	4-5	3-7	3-11	5-10	12-3
14	12	Hamilton & Laubscher			12-7	4-7	4-10	3-5	6-8	4-12	4-8	6-9	11-9
15					6-3	5-6	5-11	11-4	7-9	6-11	5-12	7-11	5-7
16					9-4	8-9	6-12	6-10	10-12	10-9	7-10	8-12	4-6
17
18		Week 1
19		=B3& " Vs. " &B9
20
21
22
23
24
25
26
Sheet1

 

[Fluff]

Are you just seeing the formula in the cell? If so check that the cell is formatted as general & then re-enter the formula.

 

[Marcílio_Lobão]

golfnut111, Good afternoon.

Hi Master Fluff. (Greetings from Brazil)

gofnut111, if you are triyng generate a TEXT table with the name of players try to use it:

Maybe at Sheet2:

A3 --> =INDEX(Sheet1!$B$3:$B$14;--LEFT(Sheet1!E3;SEARCH("-";Sheet1!E3)-1)) & " Vs. " & INDEX(Sheet1!$B$3:$B$14;--MID(Sheet1!E3;SEARCH("-";Sheet1!E3)+1;2))

You can copy it down and to right as necessary to fill till week 10.

Please, tell us if it is what you want.

I hope it helps.

 

[golfnut111]

Are you just seeing the formula in the cell? If so check that the cell is formatted as general & then re-enter the formula.

Thank you so much for your help. That was the problem. I changed the formatting to general and I worked. Thanks again. God bless you!

 

[Fluff]

Glad we could help & thanks for the feedback.