Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting problem | Excel Worksheet Functions | |||
formatting problem | Excel Discussion (Misc queries) | |||
Formatting Problem | Excel Discussion (Misc queries) | |||
Formatting Problem | Excel Programming | |||
Formatting problem | Setting up and Configuration of Excel |