Including text in formula

golfnut111

New Member
Joined
Apr 4, 2019
Messages
7
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
ABCDEFGHIJKLMNO
2TeamsWeek 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8Week 9Week 10
31Bohn & Mills1-71-121-31-81-91-41-21-61-10Fun night
42Abbate & Hamlin2-82-92-112-52-62-38-102-72-4
53Killinger & Dryer3-97-84-53-73-115-1012-311-103-8
64Dyer & Dunn4-103-56-84-124-86-911-912-95-9
75Vayer & Dryer5-1111-47-96-115-127-115-73-46-7
86Grady & Potter6-126-1010-1210-97-108-124-65-811-12
97Ginderske & Maxwell
108Ashmore &Week 11Week 12Week 13Week 14Week 15Week 16Week 17Week 18Week 19Week 20
119Hanson & Roberts1-51-111-71-121-31-81-91-41-2Fun night
1210Suitor & Richardson2-102-122-82-92-112-52-62-38-10
1311Waite & Dryer11-83-103-97-84-53-73-115-1012-3
1412Hamilton & Laubscher12-74-74-103-56-84-124-86-911-9
156-35-65-1111-47-96-115-127-115-7
169-48-96-126-1010-1210-97-108-124-6
17
18Week 1
19=B3& " Vs. " &B9
20
21
22
23
24
25
26
Sheet1
Schedule maker.xlsx
ABCDEFGHIJKLMNO
2TeamsWeek 1Week 2Week 3Week 4Week 5Week 6Week 7Week 8Week 9Week 10
31Bohn & Mills1-71-121-31-81-91-41-21-61-10Fun night
42Abbate & Hamlin2-82-92-112-52-62-38-102-72-4
53Killinger & Dryer3-97-84-53-73-115-1012-311-103-8
64Dyer & Dunn4-103-56-84-124-86-911-912-95-9
75Vayer & Dryer5-1111-47-96-115-127-115-73-46-7
86Grady & Potter6-126-1010-1210-97-108-124-65-811-12
97Ginderske & Maxwell
108Ashmore &Week 11Week 12Week 13Week 14Week 15Week 16Week 17Week 18Week 19Week 20
119Hanson & Roberts1-51-111-71-121-31-81-91-41-2Fun night
1210Suitor & Richardson2-102-122-82-92-112-52-62-38-10
1311Waite & Dryer11-83-103-97-84-53-73-115-1012-3
1412Hamilton & Laubscher12-74-74-103-56-84-124-86-911-9
156-35-65-1111-47-96-115-127-115-7
169-48-96-126-1010-1210-97-108-124-6
17
18Week 1
19=B3& " Vs. " &B9
20
21
22
23
24
25
26
Sheet1
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,856
Office Version
  1. 365
Platform
  1. Windows
Are you just seeing the formula in the cell? If so check that the cell is formatted as general & then re-enter the formula.
 
Solution

Marcílio_Lobão

Well-known Member
Joined
Oct 7, 2013
Messages
777
Office Version
  1. 2007
Platform
  1. Windows
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

New Member
Joined
Apr 4, 2019
Messages
7
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
56,856
Office Version
  1. 365
Platform
  1. Windows
Glad we could help & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,118
Messages
5,640,211
Members
417,131
Latest member
Seanr19871

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top