Conditional expressions

Spreadsheet - Text Operators

Functions
Foglio elettronico - Gli operatori di testo Folha de cálculo - Os operadores texto Tabellenkalkulation - die Textoperatoren Tableur - Les opérateurs texte

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


Last update on Thursday October 16, 2008 02:43:17 PM.This document entitled « Spreadsheet - Text Operators » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the licence, as this note appears clearly.
Best answers for « Spreadsheet Text Operators » in :
Spreadsheets - Conditional expressions Show What is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Macro help - search for text in Excel Show
Spreadsheet/Cell Question for Excel Show
Writing in batch in text file ShowWriting in batch in text file To write in a file text, you just have to use a redirect: echo text > output_file.txt To write in an existing file: echo " Write at the end of the file ">> output_file.txt
Inserting text in a file ShowInserting text in a file Introduction Syntax Introduction It is sometimes useful to insert text in the header of one or more document (s) or in a specific part of the document (before or after a specific line). The publisher of...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
Download Join (Merge) Text Files Software ShowDescription The application is designed by Sobolsoft. Simple and easy to use, the application has been awarded from various places. Join Text Files a tool that enables you to merge several files. It allows you to merge multiple text files into a...
Download Export Table To Text For Sql Server Show
Download Mobile AMR Converter ShowFormat AMR is broadly used by mobile phones to record rings or to create MM (SMS with sound, picture and text). The converter AMR for mobile phone uses the converter AMR of Sony Ericsson to convert files AMR (Adaptive Multi-Rate Codec, *.amr) in...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
They need your help