Spreadsheet - Text Operators

May 2017

Concatenation Operator

Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows:

Concatenation operator

In the above example, the cell value B15 ("Total TTC") is automatically calculated by concatenating the value of cell B13 (whose absolute reference is written $B$13), a chain made of a space " ", and the value of cell E5 (whose absolute reference is written $E$5), thanks to the following formula:

=$B$13 & " " & $E$5

Related



Tableur - Les opérateurs texte
Tableur - Les opérateurs texte
Foglio elettronico - Gli operatori di concatenazione
Foglio elettronico - Gli operatori di concatenazione
Folha de cálculo - Os operadores texto
Folha de cálculo - Os operadores texto
Latest update on October 16, 2008 at 09:43 AM by Jeff.
This document, titled "Spreadsheet - Text Operators," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).