#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default Concatenation

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default Concatenation

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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Concatenation

=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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default Concatenation

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




  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Concatenation

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



  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default Concatenation

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




  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 132
Default Concatenation

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concatenation Sol Excel Discussion (Misc queries) 5 October 23rd 07 08:03 AM
Help with Concatenation Tabit Excel Worksheet Functions 8 August 17th 07 06:52 PM
Concatenation Harry Excel Worksheet Functions 2 July 17th 06 07:17 PM
Concatenation Ken Excel Discussion (Misc queries) 1 April 12th 06 11:26 AM
concatenation mattguerilla Excel Discussion (Misc queries) 3 January 27th 06 12:47 AM


All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"