date and text concatenation
 

I tried to concatenate cell A1 with date (27.07.2005) and cell B1 with
text (INVOICE 777) by using formula in cell C1 (=A1&" "&B1)and received
the following result *38560 INVOICE 777*. But I want to see the result
as *27.07.2005 INVOICE 777*. How to avoid the date convertion? Please
advise. TIA.


--
littleps
------------------------------------------------------------------------
littleps's Profile: http://www.excelforum.com/member.php...o&userid=25482
View this thread: http://www.excelforum.com/showthread...hreadid=390537

=TEXT(A1,"dd.mm.yyyy")&" "&B1


--
Odicus
------------------------------------------------------------------------
Odicus's Profile: http://www.excelforum.com/member.php...o&userid=25610
View this thread: http://www.excelforum.com/showthread...hreadid=390537

Sure.
=TEXT(A1,"DD.MM.YYYY")&" "&B1

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390537

Try in say, C1:

=TEXT(A1,"dd.mm.yyyy")&" "&TRIM(B1)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"littleps" wrote in
message ...

I tried to concatenate cell A1 with date (27.07.2005) and cell B1 with
text (INVOICE 777) by using formula in cell C1 (=A1&" "&B1)and received
the following result *38560 INVOICE 777*. But I want to see the result
as *27.07.2005 INVOICE 777*. How to avoid the date convertion? Please
advise. TIA.


--
littleps
------------------------------------------------------------------------
littleps's Profile:
http://www.excelforum.com/member.php...o&userid=25482
View this thread: http://www.excelforum.com/showthread...hreadid=390537

Hi,

Try this: =TEXT(A1,"dd.mm.yyyy")&" "&B1

Regards,
KL


"littleps" wrote in
message ...

I tried to concatenate cell A1 with date (27.07.2005) and cell B1 with
text (INVOICE 777) by using formula in cell C1 (=A1&" "&B1)and received
the following result *38560 INVOICE 777*. But I want to see the result
as *27.07.2005 INVOICE 777*. How to avoid the date convertion? Please
advise. TIA.


--
littleps
------------------------------------------------------------------------
littleps's Profile:
http://www.excelforum.com/member.php...o&userid=25482
View this thread: http://www.excelforum.com/showthread...hreadid=390537

=TEXT(A1,"dd.mm.yyyy")&" "&B1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"littleps" wrote in
message ...

I tried to concatenate cell A1 with date (27.07.2005) and cell B1 with
text (INVOICE 777) by using formula in cell C1 (=A1&" "&B1)and received
the following result *38560 INVOICE 777*. But I want to see the result
as *27.07.2005 INVOICE 777*. How to avoid the date convertion? Please
advise. TIA.


--
littleps
------------------------------------------------------------------------
littleps's Profile:
http://www.excelforum.com/member.php...o&userid=25482
View this thread: http://www.excelforum.com/showthread...hreadid=390537

You may also wish to browse Debra's page on "Combining Data" at:
http://www.contextures.com/xlCombine01.html
(see especially the section on "Formatting examples" - scroll down)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Odicus, Olasa, Max, Bob Philips, KL,

Thanks a lot, it works perfectly. Max tks for the link.


--
littleps
------------------------------------------------------------------------
littleps's Profile: http://www.excelforum.com/member.php...o&userid=25482
View this thread: http://www.excelforum.com/showthread...hreadid=390537

You're welcome (from us <g) !

It was nice and thoughtful of you to quote
all respondents to your post in your feedback ..
(Appreciated !)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"littleps" wrote in
message ...

Odicus, Olasa, Max, Bob Philips, KL,

Thanks a lot, it works perfectly. Max tks for the link.


--
littleps
------------------------------------------------------------------------
littleps's Profile:
http://www.excelforum.com/member.php...o&userid=25482
View this thread: http://www.excelforum.com/showthread...hreadid=390537