Changes

=CONCATENATE(Text1, Text2, ...)=

=CONCATENATE(Text1, Text2, ...)=

 

<div style="font-size:30px">'''CONCATENATE () '''</div><br/>

*where, <math>Text1, Text2, ...</math> are text strings to join

*Parameters are text strings to join

 

**CONCATENATE(), joins several text items into one text item.

CONCATENATE() joins number of text strings to form one text string.

== Description ==

== Description ==

CONCATENATE(Text1, Text2, ...)

CONCATENATE()

 

*Consider the following example in ZOS,

Consider the following example in ZOS,

*CONCATENATE("JOHN"," ","SMITH") returns ''JOHN SMITH''

 

CONCATENATE("JOHN"," ","SMITH") returns ''JOHN SMITH''

 

*This function joins number of strings into one string.

*This function joins number of strings into one string.

*Arguments <math>Text1, Text2, ...</math> can be text, numbers, array or cell references, or combination of all items.

*Arguments can be text, numbers, array or cell references, or combination of all items.

*An ampersand(&) can also be used instead of CONCATENATE function.

*An ampersand(&) can also be used instead of CONCATENATE function.