Microsoft Excel 2003 - How to Join complicated Cells Together Using Text Concatenation

Worksheet - Microsoft Excel 2003 - How to Join complicated Cells Together Using Text Concatenation

Good evening. Today, I found out about Worksheet - Microsoft Excel 2003 - How to Join complicated Cells Together Using Text Concatenation. Which may be very helpful if you ask me and you. Microsoft Excel 2003 - How to Join complicated Cells Together Using Text Concatenation

One of the issues you maybe faced in Microsoft Excel 2003 is having to couple varied cells together into one single cell. For example, you may have three columns named, Title, First name and Last name and you maybe asked to couple those three values together. To accomplish this quality we use the Text Concatenation Function. This description will look at the process of combining these cells together.

What I said. It isn't the actual final outcome that the true about Worksheet. You check out this article for home elevators what you wish to know is Worksheet.

Worksheet

To begin, open Microsoft Excel 2003 and originate a new worksheet. We now want to originate a very straightforward worksheet that will allow us to join many cells together. simply originate the Microsoft Excel 2003 worksheet as shown below.

Title First Name Last name Date of Birth
Mr Joe Smith 19/10/2003
Miss Martha Henry 20/02/1945
Ms Kerry Walken 15/02/1952

You should start building the worksheet by clicking in cell A1 and the value of Title should be in this cell. The next value Mr should be in cell A2 and so forth. Once you have completed creating this worksheet then go to cell E1 and type in the word Statement, then opt E2.

What we are now going to do is to couple cell A2, B2, C2, D2 using the text concatenation function which is the ampersand & symbol. However, there is a catch ... You cannot automatically just couple Dates and Numbers with Text cells. To accomplish this quality we need to use the Text function.

Let us focus first on adding the Title, First name and Last Name together. First opt cell E2 and type the following -

= A2 & " " & B2 & " " & C2

You will notice in the method above that there is a space in the middle of the duplicate quotes. This is done to ensure that the text in the fields do not couple together, otherwise you would have a result that would look like -

MrJoeSmith

Now that we have many text cells together it is now time to look at the process of adding non-cell text and also a date to your text. To add a date to your text you must first change it to text. You accomplish this using the Text function. The Text function also allows you to format the date in a specific format. For example if I wanted a date in the following format -

09/09/2008

I would enter the Text function as -

Text( Cell Address, "dd/mm/yyyy")

Now that we have that covered it is time to couple the Date into the cell. simply type the method as follows -

= A2 & " " & B2 & " " & C2 & " was born on " & Text(D2,"dddd, dd mmmm yyyy")

The cell should now look like -

Mr Joe Smith was born on Sunday, 19 October 2003

The cool part about Text concatenation is that you can use it with Excel Database lists and couple many cells together and then use the data in the list with programs like Microsoft Word to do a mail merge. It is much easier in Microsoft Word to insert single fields then to bring many fields together.

I hope you will get new knowledge about Worksheet. Where you'll be able to put to utilization in your evryday life. And just remember, your reaction is passed about Worksheet.