Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference multiple cells
Hi all, I'm a new Excel user, I'm trying to create a taxonomy of
entities (within the Computer Science domain) and I would like a single entity (row) to have one of its records (cells) reference two separate cells elsewhere in the worksheet. Let's say one cell (F5) has the data: "testingA" And another cell (Z20) has: "testingB" then I would like my single cell to contain: "testingA and testingB" I was thinking about something like this: =$f$5 and $z$20 but that obviously didn't work. Thanks for any advice, Novice |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference multiple cells
Novice, try this =F5&Z20 or if you want and in it =F5&" and "&Z20
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address to reply by email ** "Novice" wrote in message om... Hi all, I'm a new Excel user, I'm trying to create a taxonomy of entities (within the Computer Science domain) and I would like a single entity (row) to have one of its records (cells) reference two separate cells elsewhere in the worksheet. Let's say one cell (F5) has the data: "testingA" And another cell (Z20) has: "testingB" then I would like my single cell to contain: "testingA and testingB" I was thinking about something like this: =$f$5 and $z$20 but that obviously didn't work. Thanks for any advice, Novice |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I reference multiple cells? | Excel Discussion (Misc queries) | |||
Multiple cells reference | Excel Worksheet Functions | |||
Replacing sheet reference in multiple cells... | Excel Worksheet Functions | |||
Populate multiple cells using the same reference | Excel Worksheet Functions | |||
Reference multiple cells in if statement | Excel Worksheet Functions |