| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a cell be *either text or the result of a formula? | Excel Worksheet Functions | |||
| Color a result cell in a user defined function | Excel Discussion (Misc queries) | |||
| How make text appear in a cell as a result of a number in another | Excel Discussion (Misc queries) | |||
| Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
| Comparing a cell result with a pre-defined value range | Excel Worksheet Functions | |||
Linear Mode
