Changes

*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 <math>Text1, Text2, ...</math> 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.

e.g. If cell A1=JOHN and cell A2=SMITH, then

e.g. If cell A1=JOHN and cell A2=SMITH, then

  =(A1&" "&A2) returns ''JOHN SMITH''

  =(A1&" "&A2) returns ''JOHN SMITH''

*If a text string is entered as an argument, it should be enclosed in quotes.

*Text string should be enclosed in quotes.

*If any punctuation marks to be added between two strings should also be entered as argument.

*If any punctuation marks are to be added between two strings, they should also be entered as argument.

*If arguments are omitted, Calci displays and #NULL error message.

*If arguments are omitted, Calci displays a #NULL error message.

== Examples ==

== Examples ==

{| id="TABLE2" class="SpreadSheet blue"

{| id="TABLE2" class="SpreadSheet blue"

|- class="even"

|- class="even"

| class=" " |

| class=" " |ColumnA

| ColumnA

| class=" " |ColumnB

| ColumnB

| class=" " |ColumnC

| ColumnC

| class=" " |ColumnD

| ColumnD

|- class="odd"

|- class="odd"

| class="sshl_f " | Happy

| class="sshl_f " | Happy