+ Reply to Thread
Results 1 to 5 of 5

How can I combine TEXT from two cells into single cell

  1. #1
    Registered User
    Join Date
    07-31-2014
    Location
    Australia
    MS-Off Ver
    MS Excel 2007
    Posts
    27

    How can I combine TEXT from two cells into single cell

    Hi,

    Is there a formula to combine TEXT out of two cells into a third single cell. For example

    Cell A1 contains name of region and cell B1 contains type of project. I would like to combine the cells A1 and B1 into cell C1 to show both name of region and type of project.

    Thanks for your help in advance.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,528

    Re: How can I combine TEXT from two cells into single cell

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    01-17-2014
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: How can I combine TEXT from two cells into single cell

    =CONCATENATE(A1,B1)
    or
    =A1&B1

    if you want a seperator use "
    =A1&" - "&B1

  4. #4
    Registered User
    Join Date
    07-31-2014
    Location
    Australia
    MS-Off Ver
    MS Excel 2007
    Posts
    27

    Re: How can I combine TEXT from two cells into single cell

    Thank you all. Both solutions worked.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,528

    Re: How can I combine TEXT from two cells into single cell

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Combine multiple cells text into one cell, skip blank cells.
    By T15K in forum Excel General
    Replies: 6
    Last Post: 12-05-2014, 09:49 PM
  2. [SOLVED] Combine text & date1 & date2 into one single cell - end formatting problem - Excel 2007
    By teh.format in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-12-2014, 09:10 PM
  3. formula to combine multiple cells into single cell where reference is same
    By rexer231 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-12-2014, 11:44 AM
  4. VBA to combine texts from cells to a single based on another cell value
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-04-2013, 10:05 AM
  5. [SOLVED] How can I combine text and a function in a single cell
    By slot guy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2005, 01:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1