Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!samsung!sdd.hp.com!decwrl!bacchus.pa.dec.com!jumbo!mcjones From: mcjones@src.dec.com (Paul McJones) Newsgroups: comp.sys.mac.apps Subject: Re: excel CONCAT function? Keywords: excel Message-ID: <1990Jul11.153128.22666@src.dec.com> Date: 11 Jul 90 22:31:28 GMT References: <14397@csli.Stanford.EDU> Organization: DEC Systems Research Center, Palo Alto Lines: 6 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