Concatenate with Date.

chaju · Mar 25th, 2002, 09:20 PM

Hi, I have a problem here for showing Date in concatenate function.

Suppose in Cell A1 I have '25-Mar-02', Cell B2 I have 'Hello'.
by =CONCATENATE(A1,B1) will produce output 37341Hello.

Is there any way to display the 25-Mar-02Hello instead of the above mention.

Many thanks to those who help.

[ This Message was edited by: chaju on 2002-03-25 20:21 ]

[ This Message was edited by: chaju on 2002-03-25 20:22 ]

BabyTiger · Mar 25th, 2002, 09:23 PM

Hi,

You might want to try the following:

=text(a1,"dd-mmm-yy")&b2

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

Mar 25th, 2002, 09:20 PM	#1
chaju Board Regular Join Date: Mar 2002 Posts: 82	Hi, I have a problem here for showing Date in concatenate function. Suppose in Cell A1 I have '25-Mar-02', Cell B2 I have 'Hello'. by =CONCATENATE(A1,B1) will produce output 37341Hello. Is there any way to display the 25-Mar-02Hello instead of the above mention. Many thanks to those who help. [ This Message was edited by: chaju on 2002-03-25 20:21 ] [ This Message was edited by: chaju on 2002-03-25 20:22 ]

Mar 25th, 2002, 09:23 PM	#2
BabyTiger Board Regular Join Date: Mar 2002 Location: Wellington Posts: 104	Hi, You might want to try the following: =text(a1,"dd-mmm-yy")&b2