Concatenate Date and text using excel macro

ama150 · Mar 7th, 2002, 12:30 PM

I am trying to take the current date and add text to it. The problem I am having is I need the date in this format dd/mm. Here is the final outcome I am looking for:

03/07HOLD01

I need the date to be the current date and only have 12 characters to play with.

Thanks

dk · Mar 7th, 2002, 01:20 PM

Hi,

You said you want it in dd/mm format but your example (assuming you were using today) is in mm/dd. However, you can easily change this code to whatever you need.

Regards,
D

Code:

Sub DatePlusString()
Dim strYourString
strYourString = Format(Date, "mm/dd") & "HOLD01"
MsgBox strYourString
End Sub

ama150 · Mar 7th, 2002, 02:24 PM

Worked great...thanks!!

Mar 7th, 2002, 01:20 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi, You said you want it in dd/mm format but your example (assuming you were using today) is in mm/dd. However, you can easily change this code to whatever you need. Regards, D Code: Sub DatePlusString() Dim strYourString strYourString = Format(Date, "mm/dd") & "HOLD01" MsgBox strYourString End Sub

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

Mar 7th, 2002, 12:30 PM	#1
ama150 New Member Join Date: Mar 2002 Location: Andrew Posts: 8	I am trying to take the current date and add text to it. The problem I am having is I need the date in this format dd/mm. Here is the final outcome I am looking for: 03/07HOLD01 I need the date to be the current date and only have 12 characters to play with. Thanks

Mar 7th, 2002, 02:24 PM	#3
ama150 New Member Join Date: Mar 2002 Location: Andrew Posts: 8	Worked great...thanks!!