« Rounding functions I
Financial Functions: Calculating Principal & Interest »

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

text.jpg

This entry was posted on Wednesday, March 30th, 2005 at 5:40 pm and is filed under Function Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Combining data in cells”

  1. Bob Says:
    March 1st, 2008 at 10:35 am

    I’ve gotten the concatenated string, which consists of a series of email addresses separated by a comma. Now I want to use the actual created string in an email address, but I can’t figure out how to convert the concatenated string of address into the actual resulting string of text.

    Any suggestions?

Leave a Reply