| 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? |
| 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 | |||
Threaded Mode
