Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates
joeu2004 wrote:
"GB" wrote: GB wrote: I have a whole column of dates nicely formatted the way I want (eg "Wednesday 28 December 2011"). I want to concatenate those dates with an another column of text. [....] what I wanted was Wednesday 28 December 2011 <followed by the text I added [....] I found this link, and the solution there works, but is there nothing more straightforward? http://office.microsoft.com/en-us/ex...003056124.aspx Don't know you standard for "straigtht-forward". That's basic the way to do it. If your dates are in A1:A1000 and your additional text is in B1:B1000, put the following formula into C1 and copy down through C1000: =TEXT(A1,"dddd dd mmmm yyyy") & " " & B1 That assumes you want to separate the date and additional text by one space, and the text in column B does not start with a space. If you want the new values in C1:C1000 to overwrite either A1:A1000 or B1:B1000, you can copy C1:C1000, select A1:A1000 for example, right-click and click on Paste Special, select Values, then click OK. If all the text in column B are the same, you could simply format A1:A1000 with the following Custom date: dddd dd mmmm yyyy" yourText" And you could dispense with either change by writing a macro. But that does not meet __my__ definition of "straight-forward" ;-). Thanks for your helpful answer, confirming that's the way to do it. -- Register as an organ donor with the NHS online. It takes 1 minute and saves you carrying an organ donor card with you. http://www.uktransplant.org.uk/ukt/h...me_a_donor.jsp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
how do I sort a column of random dates into Consecutive dates | Excel Worksheet Functions | |||
Identifying unique dates within a range of cells containing dates | Excel Discussion (Misc queries) |