concat

1. Syntax:

Value String  concat(Range range)

Description:

Concatinates the values in range.

2. Syntax:

Value String  concat(List String list)

Description:

Concatinates the values in list.

Examples:

($c1:$c5) = concat($a:$b)
Before:
AB C
1Hello World
2My Name is Alex
3ABC
44.56789
5XSS
616
After:
AB C
1Hello World Hello World
2My Name is Alex My Name is Alex
3ABC ABC
44.56789 4.56789
5XSS XSS
616
($d1:$d10) = concat($a, $c)