excel CONCAT function?

Thread View: comp.sys.mac.apps

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Alan Ramaley Wed, 11 Jul 1990 20:23

#3322

Author: Alan Ramaley
Date: Wed, 11 Jul 1990 20:23

5 lines
686 bytes

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

Re: excel CONCAT function?

#3323

Author: Paul McJones
Date: Wed, 11 Jul 1990 22:31

6 lines
614 bytes

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

Re: excel CONCAT function?

#3334

Author: Benoit MINSTER
Date: Thu, 12 Jul 1990 11:10

4 lines
511 bytes

An operator does the job: it's &. for instance: "hello" & " world" 
returns "hello world". I hope this will help you.

Benoit.

Re: excel CONCAT function?

#3337

Author: Jann VanOver
Date: Thu, 12 Jul 1990 15:48

19 lines
1114 bytes

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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads