Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!cornell!uw-beaver!ssc-vax!bcsaic!vanover
From: vanover@bcsaic.UUCP (Jann VanOver)
Newsgroups: comp.sys.mac.apps
Subject: Re: excel CONCAT function?
Message-ID: <27880@bcsaic.UUCP>
Date: 12 Jul 90 15:48:21 GMT
References: <14397@csli.Stanford.EDU>
Organization: Boeing Computer Services AI Center, Seattle
Lines: 19
Keywords: excel

In article <14397@csli.Stanford.EDU> ramaley@csli.Stanford.EDU (Alan Ramaley) writes:
>Boring question, but no one around here seems to know the answer.  I'm
>sure there's a function in excel that takes two strings and concat's
>them, returning a string, but I can't for the life of me find it.  Any
>one have any clues?
>							--Alan

Hi Alan!
 
This task is simpler even than a function.  Excel has a concatenation
"OPERATOR"!  it is the "&".  Just put two strings, or expressions next
to each other with the & in between.  For example, to build a row/column
reference:
   "R[-"&NumRowsBack&"]C"    if NumRowsBack = 2, this will produce "R[-2]C"


Have Fun!
Jann VanOver
vanover@atc.boeing.com