+ Reply to Thread
Results 1 to 6 of 6

Combine 2 cells

  1. 07-25-2018, 12:24 PM #1
    ionelz
    ionelz is offline
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    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...
    Reply With QuoteRegister To Reply
  2. 07-25-2018, 12:25 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    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
    Reply With QuoteRegister To Reply
  3. 07-25-2018, 02:11 PM #3
    ionelz
    ionelz is offline
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    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
    Reply With QuoteRegister To Reply
  4. 07-25-2018, 02:18 PM #4
    ionelz
    ionelz is offline
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Office 365 Version 2008 (July 2020)
    Posts
    819

    Re: Combine 2 cells

    So formula is in Header row !
    Reply With QuoteRegister To Reply
  5. 07-25-2018, 02:32 PM #5
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Combine 2 cells

    I don't follow what you mean, can you post a desensitized sample with expected results?
    Reply With QuoteRegister To Reply
  6. 07-25-2018, 03:22 PM #6
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1