Concatenate Text and Date

[satyamsaurabh]

Is there a way to concatenate the following:

A1= DELETED
A2= 08/01/07

The result in A3 should display 'DELETED 08/01/07'

Any help would be greatly appreciated.

Thank you.

 

[VoG]

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

 

[satyamsaurabh]

I am getting the following result DELETED 00/01/00, as opposed to DELETED 08/01/07. Can you help, please.

 

[VoG]

If you are using American-style dates maybe you need

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

 

[Richard Schollar]

Hi

Is A2 an actual date? If so, you should be getting the desired result.

 

[satyamsaurabh]

Yes, it works. Thank you for your help. I really appreciate it.