Merging cells with different notations:

If you do not know how to merge cells, first read Lesson 31 – Excel 2010 course

In the first example, I want to merge two cells which contain text and the third cell which has a date.
If we add these cells in a “normal” way, we have a problem.
When we type the cell reference (1) of cell C2 in a formula in Excel, it will display the date as a number (2).  This number is the number of days since January 1, 1900, till the date “Piet Verbleken” was born. It maybe interesting for “Piet Verbleken” but not for us.

To format the contents of these cells i.e, for the date to be displayed in a proper way, we must add a function to the formula. we can do this with the TEXT function.

Delete everything after the last ampersand in the formula and type TEXT (C2, “mm / dd / yyyy”)).
Do not forget to close the parentheses twice at the end of the formula.
You need to do this because they were opened twice.
Once at the beginning of the formula and once at the beginning of the second function.

It looks a lot better now:

You can change the date format by typing one or more letters in the formula.
For example:
dddd indicates the full name of the day.
mmmm give the full name of the month.
dddd d displays the full name of the day and the number of the day.

Here you need to experiment a bit.

Example 2:
You can also use an additional feature when you want to merge text with currency.
Just use the EURO function.

Combining both together:

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats