Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea

I put '10-Jan in A1 and 40 in B1. In C1, I put =A1&B1 and I get 10-Jan40. I
used the single apostrophe to tell Excel that 10-Jan is text, not a date.

Tyro

"orquidea" wrote in message
...
Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea

=TEXT(A1,"d-mmm")&B1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"orquidea" wrote in message
...
Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea

Thanks Tyro

It works if I enter the dates with the single aposthophe ahead of the dates,
but in my spreadsheet dates come from other data base with the date formats.
Is there anyway I can get this concatenation without changing the date format?


"Tyro" wrote:

I put '10-Jan in A1 and 40 in B1. In C1, I put =A1&B1 and I get 10-Jan40. I
used the single apostrophe to tell Excel that 10-Jan is text, not a date.

Tyro

"orquidea" wrote in message
...
Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea

If the value in A1 is actually a date, then use this.........

=TEXT(DATE(B1,MONTH(A1),DAY(A1)),"dd-mmmyy")

Vaya con Dios,
Chuck, CABGx3




"orquidea" wrote:

Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea

Thanks, it worked

"Bob Phillips" wrote:

=TEXT(A1,"d-mmm")&B1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"orquidea" wrote in message
...
Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea

Thanks, it worked

"CLR" wrote:

If the value in A1 is actually a date, then use this.........

=TEXT(DATE(B1,MONTH(A1),DAY(A1)),"dd-mmmyy")

Vaya con Dios,
Chuck, CABGx3




"orquidea" wrote:

Hi

I want to cancatenate 2 columns
A B
10-Jan 40
The result I am getting is "0-Jan", instead of "10-Jan40".

Could anyone let me know how I can fix it.

Thanks
Orquidea