ramaley@csli.Stanford.EDU (Alan Ramaley) (07/12/90)
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
mcjones@src.dec.com (Paul McJones) (07/12/90)
One way to concatenate x and y is to use the expression REPLACE(y,1,0,x). In other words, replace the first zero characters of y with x. Paul McJones mcjones@src.dec.com
keir@vms.macc.wisc.edu (Rick Keir, MACC) (07/12/90)
Try =a1&b1 to concatenate the contents of cells a1 and b1. This *is* in the manual; but to be fair, Excel comes with hundreds of pages of documentation, so it is sometimes easy to miss an obvious answer.
benoit@hpgnd.HP.COM (Benoit MINSTER) (07/12/90)
An operator does the job: it's &. for instance: "hello" & " world" returns "hello world". I hope this will help you. Benoit.
vanover@bcsaic.UUCP (Jann VanOver) (07/12/90)
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