Results 1 to 2 of 2

Thread: Topic 36: Excel Text Concatenation: How to Join Multiple Cell Together?

  1. #1
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10

    Topic 36: Excel Text Concatenation: How to Join Multiple Cell Together?

    Advertisement

    To use the Excel text concatenation feature

    • Open Microsoft Excel 2003 and create the worksheet as shown below:


    • Go to cell E1 and type in the word Result, then select the cell E2. We are going to combine cell A2, B2, C2, D2 using the text concatenation function which is the ampersand (&) symbol.
    • However, we cannot automatically just combine Dates and Numbers with Text cells. We need to use the TEXT function.
    • " Let us focus first on adding the Title, First name and Last Name together. First select cell E2 and type the following formula:Advertisement

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

    Note: There is a space between the double quotes. This is to ensure that the text in the fields do not combine together without spacing.

  2. #2
    Administrator
    Join Date
    Oct 2009
    Posts
    5,607
    Rep Power
    10
    To add a date to the text
    • To add a date to the text we must first convert it to text using the TEXT function. The TEXT function also can be use to format the date in a specific format.
    • For example if I wanted a date in the format - 09/12/2008, I would enter the Text function as - TEXT(Cell Address, "dd/mm/yyyy")
    • To incorporate the Date into the cell, simply type the formula as follows - = A2 & " " & B2 & " " & C2 & " was born on " & Text(D2,"dddd, dd mmmm yyyy")
    • The result will be - Mr John Harvest was born on Sunday, 12 October 1980..

    The good part about Excel Text concatenation is that you can use it with Excel Database lists and combine multiple cells together and then use the data in the list with programs like Microsoft Word to do a mail merge.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •