concatenate date + text

[Eddie G.]

Is there any way to concatenate a date and text:
cell a1 is a date 03/11/02
cell a2 is text 96% - Good
cell a3 is a comma ,

i want to concatenate all three:
03/11/02, 96% - Good
but the date comes out as a number 35755 or similar.

 

[Aladin Akyurek]

I don't see the comma from A3 in the result that you show -- Is that intended?

 

[dk]

Hi,

Try this:-

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

If you're using a different date format then change as necessary.

 

[DonkeyOte]

On 2002-11-03 10:15, Eddie G. wrote:
Is there any way to concatenate a date and text:
cell a1 is a date 03/11/02
cell a2 is text 96% - Good
cell a3 is a comma ,

i want to concatenate all three:
03/11/02, 96% - Good
but the date comes out as a number 35755 or similar.

Dan just to be pedantic I think it should be:

=text(a1,"dd/mm/yy") & A3 & " " & A2

 

[Aladin Akyurek]

On 2002-11-03 14:29, lasw10 wrote:

On 2002-11-03 10:15, Eddie G. wrote:
Is there any way to concatenate a date and text:
cell a1 is a date 03/11/02
cell a2 is text 96% - Good
cell a3 is a comma ,

i want to concatenate all three:
03/11/02, 96% - Good
but the date comes out as a number 35755 or similar.

Dan just to be pedantic I think it should be:

=text(a1,"dd/mm/yy") & A3 & " " & A2

I see you're trying to resolve the comma problem!