#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default 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
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
Linking computer dates (time) to spreadsheet dates that have formu bigisle Excel Worksheet Functions 3 January 3rd 10 09:05 PM
Stop dates from showing as numbers - when formated as dates JR Excel Discussion (Misc queries) 1 October 29th 08 05:38 PM
compare 2 tables of dates to find the preceding dates Babi Excel Worksheet Functions 3 October 28th 08 06:52 AM
how do I sort a column of random dates into Consecutive dates Rob Gibson Excel Worksheet Functions 2 June 12th 07 05:10 AM
Identifying unique dates within a range of cells containing dates cdavidson Excel Discussion (Misc queries) 0 October 12th 06 08:19 PM


All times are GMT +1. The time now is 09:58 PM.

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"