Concatenate text string with date

lewda · Mar 4th, 2002, 03:08 PM

I'm having problems concatenating a text string with a date (formatted mm/dd-yy). Have already tried several date conversions, along with using other functions within functions, but without success.

Can someone please suggest a solution? Thanks in advance. DHL

Mark W. · Mar 4th, 2002, 03:15 PM

="Your text here "&TEXT(date,"mm/dd/yy")

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

Mar 4th, 2002, 03:08 PM	#1
lewda New Member Join Date: Mar 2002 Posts: 1	I'm having problems concatenating a text string with a date (formatted mm/dd-yy). Have already tried several date conversions, along with using other functions within functions, but without success. Can someone please suggest a solution? Thanks in advance. DHL

Mar 4th, 2002, 03:15 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	="Your text here "&TEXT(date,"mm/dd/yy")