View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Novice[_11_] Novice[_11_] is offline
external usenet poster
 
Posts: 1
Default 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