Back to all functions

In this lesson we are going to have a look at how to join together multiple strings of text using the ampersand, as well as find the length of any string using the LEN function.
To join together two strings of text, held in different cells, we use the ampersand in between the references to those cells. In between each reference we can also add any additional text that we want, such as a space.
To count the number of characters in a string of text, we use the LEN function. It consists of only one argument: the cell containing the text we want to count.
We’ll type Equals, LEN, and select the cell. We see that the cell contains 11 characters.
In this lesson we have gone through joining, as well as getting the length of, strings of text.