Concatenation...

believer · May 24th, 2002, 04:33 PM

I'm trying to concatenate dates in two columns into a third. The entries in A1 and B1 are in mm/dd/yy format, ie, 05/23/96 and 11/09/98. In G1 I typed: =A1&"-"&B1. What resulted was 35208-36108, which represents those dates in serial format. How can I get that to appear as mm/dd/yy? Thanks.

Mark W. · May 24th, 2002, 04:38 PM

=TEXT(A1,"mm/dd/yy - ")&TEXT(B1,"mm/dd/yy")

believer · May 24th, 2002, 05:02 PM

Thanks, Mark. Works fine.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 04:33 PM	#1
believer Join Date: Feb 2002 Location: East Coast Posts: 23	I'm trying to concatenate dates in two columns into a third. The entries in A1 and B1 are in mm/dd/yy format, ie, 05/23/96 and 11/09/98. In G1 I typed: =A1&"-"&B1. What resulted was 35208-36108, which represents those dates in serial format. How can I get that to appear as mm/dd/yy? Thanks.

May 24th, 2002, 04:38 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,653	=TEXT(A1,"mm/dd/yy - ")&TEXT(B1,"mm/dd/yy")

May 24th, 2002, 05:02 PM	#3
believer Join Date: Feb 2002 Location: East Coast Posts: 23	Thanks, Mark. Works fine.