Text and defined name result in same cell
 

I am trying to create a schedule for several teams. Each team has a defined
name (Team1, Team2 etc). I want a spreadsheet something like this:

A1: Week 1 Games
A2: Team1 B2: at Team2
A3: Team3 B3: at Team4
A4: Team5 B4: at Team6 etc.

where the home team displays "at " and the value for Team# in the same cell.

How do I write such a formula?

Text and defined name result in same cell
 

In Column B, just type in the team names WITHOUT the word "at" and use this
Custom Format...

"at "@

for the cells from B2 to Bnn where nn is the highest numbered row you ever
expect to use.

Rick


"Kano in PA" <Kano in wrote in message
...
I am trying to create a schedule for several teams. Each team has a
defined
name (Team1, Team2 etc). I want a spreadsheet something like this:

A1: Week 1 Games
A2: Team1 B2: at Team2
A3: Team3 B3: at Team4
A4: Team5 B4: at Team6 etc.

where the home team displays "at " and the value for Team# in the same
cell.

How do I write such a formula?

Text and defined name result in same cell
 

wow - you are my hero! Worked like a charm

"Rick Rothstein (MVP - VB)" wrote:

In Column B, just type in the team names WITHOUT the word "at" and use this
Custom Format...

"at "@

for the cells from B2 to Bnn where nn is the highest numbered row you ever
expect to use.

Rick


"Kano in PA" <Kano in wrote in message
...
I am trying to create a schedule for several teams. Each team has a
defined
name (Team1, Team2 etc). I want a spreadsheet something like this:

A1: Week 1 Games
A2: Team1 B2: at Team2
A3: Team3 B3: at Team4
A4: Team5 B4: at Team6 etc.

where the home team displays "at " and the value for Team# in the same
cell.

How do I write such a formula?