+ Reply to Thread
Results 1 to 4 of 4

Combining Cells-how do I combine the results of 3 columns

  1. #1
    Registered User
    Join Date
    05-13-2009
    Location
    melrose, nb
    MS-Off Ver
    Excel 2003
    Posts
    32

    Combining Cells-how do I combine the results of 3 columns

    Probably an extremely stupid question but how do I combine the results of 3 columns? For example in A1 I have 2071000, in B1 I have / and in C1 I have A.

    End result should be 2071000 / A.

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    re: Combining Cells-how do I combine the results of 3 columns

    Try this:
    Please Login or Register  to view this content.
    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    re: Combining Cells-how do I combine the results of 3 columns

    Try =CONCATENATE(A1, B1, C1)

    but if you want them separate you'll need:

    =CONCATENATE(A1, " ", B1, " ", C1)

  4. #4
    Registered User
    Join Date
    05-13-2009
    Location
    melrose, nb
    MS-Off Ver
    Excel 2003
    Posts
    32

    re: Combining Cells-how do I combine the results of 3 columns

    Quote Originally Posted by Ron Coderre View Post
    Try this:
    Please Login or Register  to view this content.
    Does that help?
    For the love of God!! I had the same thing but had VALUE outside brackets of your formula.

    Thanks and sorry for being an idiot!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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