Ask Experts Questions for FREE Help !
Ask
    Wonder84lalala's Avatar
    Wonder84lalala Posts: 41, Reputation: 1
    Junior Member
    		  
    #1

    Nov 20, 2006, 01:22 PM
    Excel: CONCATENATE(B2,"-",B3,"-",B4)
    Hi,

    I would like to concatenate three rows: (Row2, Row3, Row4) of Col A to Row1 of Col B below. I did CONCATENATE(B2,"-",B3,"-",B4), the result was 39065-Thurs-1pm ET. I want the result to become: 11/20/2006-Thurs-1pm ET. Please help. Thanks


    Column A Column B
    Row1 Event date (Col A) 39065-Thurs-1pm ET
    Row2 Date (Col A) 11/20/2006 (Col B)
    Row3 Day of week (Col A) Thurs (Col B)
    Row4 Start time and time zone (Col A) 1pm ET (Col B)
    Depressed in MO's Avatar
    Depressed in MO Posts: 571, Reputation: 94
    Senior Member
    		  
    #2

    Nov 20, 2006, 01:54 PM
    Did you do B2 in the first line
    "/" in the second line
    B3 in the third line
    /... etc??
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Nov 20, 2006, 02:04 PM
    Use:

    CONCATENATE(Text(B2,"mm/dd/yy"),"-",B3,"-",B4)

    Excel stores the date as a number counting the days from 12/30/1899 so you need to convert to a date.
    Depressed in MO's Avatar
    Depressed in MO Posts: 571, Reputation: 94
    Senior Member
    		  
    #4

    Nov 20, 2006, 02:18 PM
    Quote Originally Posted by ScottGem
    Use:

    CONCATENATE(Text(B2,"mm/dd/yy"),"-",B3,"-",B4)

    Excel stores the date as a number counting the days from 12/30/1899 so you need to convert to a date.
    Thanks, Scott Gem! I couldn't quite word this right-I just did this the other day too! Silly me:o
    Wonder84lalala's Avatar
    Wonder84lalala Posts: 41, Reputation: 1
    Junior Member
    		  
    #5

    Nov 21, 2006, 08:35 AM
    Thanks guys, it was very helpful.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Fan Blower not working in "ON" or "AUTO" in heat or AC [ 13 Answers ]

Got home from the Brewer game this afternoon and noticed the house was warm(78). Outside was 91. I checked the T-stat and it was set correct. Noticed the air vents weren't blowing anything. Went outside and the condenser and fan was running fine. Then I went downstairs to the furnace unit to see...

Pink pill with "watson" and "502" on it [ 2 Answers ]

What kind of pill is pink and has watson 502 on it?

Heater blows cold when "On", not at all on "Auto" [ 1 Answers ]

Our gas heater is 7 years old, and has worked fine in the two years we've rented here. This winter though, we can't get it to work consistently. When on "Auto", it doesn't turn on at all, no matter what temperature we select, and when we turn the fan to "On", it simply blows cold air. It...

Excel line chart with "confidence band" [ 0 Answers ]

Hello, I am new to this forum and need help with a line chart in Excel. I have 40 years of annual data, each expressed as a mean with a confidence interval (CI) having an upper limit (UL) and a lower limit (LL). Instead of plotting the data using error bars to show the CI, I wanted to plot 3...

View more questions Search