date and text concatenation

[littleps]

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.

[Odicus]

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

[olasa]

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

HTH
Ola Sandström

[Max]

Try in say, C1:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"littleps" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Bob Phillips]

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

--

HTH

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


"littleps" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[KL]

Hi,

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

Regards,
KL


"littleps" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Max]

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 <at>yahoo<dot>com
----

[littleps]

Odicus, Olasa, Max, Bob Philips, KL,

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

[Max]

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 <at>yahoo<dot>com
----
"littleps" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>