+ Reply to Thread
Results 1 to 3 of 3

Putting Results of two cells in one cell with correct formating

  1. #1
    Forum Contributor
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    136

    Putting Results of two cells in one cell with correct formating

    Hello All!

    I am trying to get headings on a spreadsheet using formulas. I have three columns B C and E.

    In B3 I have the result Dec-14 from entering the following formula =A1
    In C3 I have the result Nov-14 from entering the following formula =DATE(YEAR(A1),MONTH(A1)-1,DAY(A1))

    In E3 I would like the result Dec-14 vs Nov-14

    I tried =B3&" vs "&C3 which returns 41974 vs 41944 While this is technically what I asked for I cannot get it to format correctly. Changing the cell format doesn't work.
    I also tried =TEXT(B3,mmm-yy)&" vs "&TEXT(C3,mmm-yy) which gives me the error #NAME

    Any help would be greatly appreciated!

  2. #2
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Putting Results of two cells in one cell with correct formating

    You need

    =TEXT(B3,"mmm-yy")&" vs "&TEXT(C3,"mmm-yy")
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    06-26-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Putting Results of two cells in one cell with correct formating

    Man I was so close. Thanks for help!

+ 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] Conditional Formating - 2 rules and results in one cell
    By jono7gold in forum Excel General
    Replies: 4
    Last Post: 07-16-2014, 07:58 AM
  2. Putting the results of a vlookup into a cell's comment
    By trishcollins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2014, 04:38 PM
  3. Replies: 1
    Last Post: 02-14-2012, 05:45 PM
  4. copy data/results into correct cell in different worksheet
    By eugbed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2010, 07:04 PM
  5. vlookup: I have to double click each cell to get correct results?
    By gillyd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2006, 09:10 AM

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