+ Reply to Thread
Results 1 to 6 of 6

Combine 2 cells

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    787

    Combine 2 cells

    In cell A1 I have Name
    In cell B1 I have 7


    I want in C1 Name x 7
    If I change to 13 in B1 the in C1 should be Name x 13...

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Combine 2 cells

    is this what you want? =A1&" x "&B1
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    787

    Re: Combine 2 cells

    Yes ,it is working in a regular cell.
    But I want this to be the Table Column Name and for some reason it is not working in that cell

  4. #4
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    787

    Re: Combine 2 cells

    So formula is in Header row !

  5. #5
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,596

    Re: Combine 2 cells

    I don't follow what you mean, can you post a desensitized sample with expected results?

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,718

    Re: Combine 2 cells

    Quote Originally Posted by ionelz View Post
    So formula is in Header row !
    I don't believe that will work in Table headers. I tried it on a Table I had and the formula returns 0.

    Is that what you are getting?
    Dave

+ 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] Need to combine cells to one string of text if duplicate values exist in multiple cells
    By Chris McGlothen in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-17-2017, 09:13 PM
  2. Combine text from multiple cells based on criteria from other cells
    By t2cool in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2017, 12:03 PM
  3. [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
  4. [SOLVED] Macro to combine cells in a row to 1 cell while skipping blank cells
    By ywang in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2014, 10:39 AM
  5. [SOLVED] Macro to combine cells in a row to 1 cell while skipping blank cells
    By ywang in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2014, 07:41 PM
  6. [SOLVED] Combine cells in column A if the cells blank in between in columnB
    By coronakyk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-11-2014, 06:17 AM
  7. Combine multiple text cells if value exists in other cells
    By epoch555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 03:50 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