Combining data in cells

March 30th, 2005

A few examples showing how data from multiple cells can be combined - as well
as how data can be combined with text and with extra formatting. A useful
function is the TEXT()( function. We will look at some examples.

A few examples showing how data from multiple cells can be combined - as well
as how data can be combined with text and with extra formatting. A useful
function is the TEXT()( function. We will look at some examples.

It is straightforward to merge text data from different cells. The
& - Ampersand operator is used to concatenate text from different
sources. This is shown below in C3

Numerical data can also be combined with text using the & operator - such
as in C6 below.

For special data types - such as dates and curencies, we need to use the
TEXT() function, which returns a value converted to text with a
specified format. A few examples are shown in C9 and C12

Дата добавления: 2015-08-03