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

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