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)

Did you do B2 in the first line
"/" in the second line
B3 in the third line
/... etc??

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.

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

Thanks guys, it was very helpful.