date Concatenation
in [Functions]
|
From: gb_S49 on 11 Apr 2010 09:08 Hi, I am trying to date Concatenate 2 cells. One contains text the other date. How can I get the date to display as a date? =T6&" "&U6 returns ESTIMATE 40066
From: Russell Dawson on 11 Apr 2010 09:19 That's because the CONCATENATE formula joins two text strings together. The result you are getting is converting the date 10/09/2009 (UK) into text. Perhaps you should approach from another angle. What are you trying to achieve? Why do you need to join these two cells in this way? -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "gb_S49" wrote: > Hi, > I am trying to date Concatenate 2 cells. One contains text the other date. > How can I get the date to display as a date? > =T6&" "&U6 returns ESTIMATE 40066 >
From: gb_S49 on 11 Apr 2010 09:24 I need to know the date of a movement for a report. The colomns contain over 2,000 rows. "Russell Dawson" wrote: > That's because the CONCATENATE formula joins two text strings together. > The result you are getting is converting the date 10/09/2009 (UK) into text. > Perhaps you should approach from another angle. > What are you trying to achieve? Why do you need to join these two cells in > this way? > > -- > Russell Dawson > Excel Student > > Please hit "Yes" if this post was helpful. > > > "gb_S49" wrote: > > > Hi, > > I am trying to date Concatenate 2 cells. One contains text the other date. > > How can I get the date to display as a date? > > =T6&" "&U6 returns ESTIMATE 40066 > >
From: T. Valko on 11 Apr 2010 09:29 >How can I get the date to display as a date? >=T6&" "&U6 returns ESTIMATE 40066 For the date in m/d/yyyy format... =T6&" "&TEXT(U6,"m/d/yyyy") -- Biff Microsoft Excel MVP "gb_S49" <gbS49(a)discussions.microsoft.com> wrote in message news:783D01EC-22A7-4444-905F-E71A6EFBE57A(a)microsoft.com... > Hi, > I am trying to date Concatenate 2 cells. One contains text the other date. > How can I get the date to display as a date? > =T6&" "&U6 returns ESTIMATE 40066 >
From: gb_S49 on 11 Apr 2010 09:51
Thanks for your assistance but now sorted :-) ESTIMATE 08,Apr 2010 =T20&" "&TEXT(U20,"dd,MMM yyyy") "Russell Dawson" wrote: > That's because the CONCATENATE formula joins two text strings together. > The result you are getting is converting the date 10/09/2009 (UK) into text. > Perhaps you should approach from another angle. > What are you trying to achieve? Why do you need to join these two cells in > this way? > > -- > Russell Dawson > Excel Student > > Please hit "Yes" if this post was helpful. > > > "gb_S49" wrote: > > > Hi, > > I am trying to date Concatenate 2 cells. One contains text the other date. > > How can I get the date to display as a date? > > =T6&" "&U6 returns ESTIMATE 40066 > > |