Concatenation

O

orquidea

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
 
T

Tyro

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
 
B

Bob Phillips

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

--
---
HTH

Bob


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

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?
 
C

CLR

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
 
O

orquidea

Thanks, it worked

CLR said:
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
Click to expand...
 
Top