formatting problem
 

I have two cells in a spreadhseet. One cell contains some text and the
other a date.

I wnat a thrid cell to contain the text from the first cell plus the
date from the second formatted as a date. Cell A2 contains the text
(TURKEY) cell K2 contains the date (25 June 2010) here's my code in
the results cell: =A2 &K2 here's the results as displayed in the
results cell: TURKEY40354

What I want to acheive is TURKEY 25 June 2010 in the results cell.

Anyone know how I might achieve it, I've tried a few format formulas
but they keep asking for arguments that I don't know how to enter, any
help much appreciated.

Thanks and regards, Mark

formatting problem
 

On Thu, 8 Jul 2010 17:33:17 -0700 (PDT), dial13
wrote:

I have two cells in a spreadhseet. One cell contains some text and the
other a date.

I wnat a thrid cell to contain the text from the first cell plus the
date from the second formatted as a date. Cell A2 contains the text
(TURKEY) cell K2 contains the date (25 June 2010) here's my code in
the results cell: =A2 &K2 here's the results as displayed in the
results cell: TURKEY40354

What I want to acheive is TURKEY 25 June 2010 in the results cell.

Anyone know how I might achieve it, I've tried a few format formulas
but they keep asking for arguments that I don't know how to enter, any
help much appreciated.

Thanks and regards, Mark

=A2 & text(k2," dd mmmm yyyy")

formatting problem
 

On Jul 9, 8:33*am, dial13 wrote:
I have two cells in a spreadhseet. One cell contains some text and the
other a date.

I wnat a thrid cell to contain the text from the first cell plus the
date from the second formatted as a date. Cell A2 contains the text
(TURKEY) cell K2 contains the date (25 June 2010) here's my code in
the results cell: =A2 &K2 here's the results as displayed in the
results cell: TURKEY40354

What I want to acheive is TURKEY 25 June 2010 in the results cell.

Anyone know how I might achieve it, I've tried a few format formulas
but they keep asking for arguments that I don't know how to enter, any
help much appreciated.

Thanks and regards, Mark

THANK YOU VERY MUCH WORKS LIKE A DREAM:) MUCH APPRECIATED

formatting problem
 

On Fri, 9 Jul 2010 03:19:34 -0700 (PDT), dial13
wrote:

On Jul 9, 8:33*am, dial13 wrote:
I have two cells in a spreadhseet. One cell contains some text and the
other a date.

I wnat a thrid cell to contain the text from the first cell plus the
date from the second formatted as a date. Cell A2 contains the text
(TURKEY) cell K2 contains the date (25 June 2010) here's my code in
the results cell: =A2 &K2 here's the results as displayed in the
results cell: TURKEY40354

What I want to acheive is TURKEY 25 June 2010 in the results cell.

Anyone know how I might achieve it, I've tried a few format formulas
but they keep asking for arguments that I don't know how to enter, any
help much appreciated.

Thanks and regards, Mark

THANK YOU VERY MUCH WORKS LIKE A DREAM:) MUCH APPRECIATED

You're welcome. Glad to help. Thanks for the feedback.