« Rounding functions I | Main | Financial Functions: Calculating Principal & Interest »
March 30, 2005
Combining data in cells
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
Posted by Dave at March 30, 2005 06:31 AM