Re: String concatination operator in Excel?

Article View: comp.apps.spreadsheets

Article #11

Back to comp.apps.spreadsheets Previous Next

#11

From: Tom Fisher
Date: Thu, 29 Oct 1992 18:28

13 lines
1019 bytes

From article <1992Oct29.141845.22361@seas.gwu.edu>, by dblack@seas.gwu.edu (David K. Black):
> Unbelievable as it may seem I can't figure out how to concatinate two
> strings in Excel 4.0 (Mac) There is no "concat" function and using the
> "+" a la basic returns a #VALUE error.  Help desperately needed
> please!  Email prefered.  Thanks
>
The "&" is what you need.  Let's say you wish to concatinate the
contents of cell a1 with the contents of b1 and have the result
in cell c1.  In cell c1, enter "=a1&b1"  .  That's it.

Tom

Technical Details

Message-ID: <1992Oct29.182847.22576@CERIS.Purdue.EDU>

Path: arc1-ca.pugleaf.net!sparky!uunet!decwrl!purdue!mentor.cc.purdue.edu!npirs!tfisher

References: <1992Oct29.141845.22361@seas.gwu.edu>

Show Full Headers

Complete Article Headers

Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!decwrl!purdue!mentor.cc.purdue.edu!npirs!tfisher
From: tfisher@CERIS.Purdue.EDU (Tom Fisher)
Subject: Re: String concatination operator in Excel?
Message-ID: <1992Oct29.182847.22576@CERIS.Purdue.EDU>
Organization: Center for Environmental and Regulatory Information Systems, Purdue University
References: <1992Oct29.141845.22361@seas.gwu.edu>
Distribution: usa
Date: Thu, 29 Oct 1992 18:28:47 GMT
Lines: 13

Reply to Parent Message