Concatenate

Matt · Feb 18th, 2002, 04:18 AM

I'm having problems concatenating a text formatted cell with a date formatted cell. Each time that I try to concatenate the 2n cells the date reverts back to the code e.g. 37305 rather than retaining the date format 19/01/02. Does anyone have any ideas to get around this.

Thanks

Matt

Aladin Akyurek · Feb 18th, 2002, 04:27 AM

Matt,

Try:

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

where A1 houses a text value and B1 a date.

Aladin

Feb 18th, 2002, 04:28 AM

If your text is in A1 and your date in A2 :-

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

Matt · Feb 18th, 2002, 04:33 AM

That's worked a treat, Thanks alot

Matt

Feb 18th, 2002, 04:35 AM

Quote:

On 2002-02-18 03:27, Aladin Akyurek wrote:
Matt,

Try:

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

where A1 houses a text value and B1 a date.

Aladin

Adding a space to the concatenation is not necessary.
Instead, the formula could entered as :-
=A1&TEXT(B1," dd/mm/yy")

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

Feb 18th, 2002, 04:18 AM	#1
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	I'm having problems concatenating a text formatted cell with a date formatted cell. Each time that I try to concatenate the 2n cells the date reverts back to the code e.g. 37305 rather than retaining the date format 19/01/02. Does anyone have any ideas to get around this. Thanks Matt

Feb 18th, 2002, 04:27 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	Matt, Try: =A1&" "&TEXT(B1,"dd/mm/yy") where A1 houses a text value and B1 a date. Aladin

Feb 18th, 2002, 04:28 AM	#3
Guest Posts: n/a	If your text is in A1 and your date in A2 :- =A1 & TEXT(A2,"d/mm/yy")

Feb 18th, 2002, 04:33 AM	#4
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	That's worked a treat, Thanks alot Matt