| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
concatenating
im trying to concatenate a text and date cell. is this possible?
i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenating
One way: put an apostrophe to the left of the date so that XL treats it as a
text string and not a date. But that's cheating. There's probably a more elegant way. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Yosh" wrote: im trying to concatenate a text and date cell. is this possible? i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenating
=A1&TEXT(A2,"mm/dd/yyyy")
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message ups.com... im trying to concatenate a text and date cell. is this possible? i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenating
On Feb 7, 1:35 pm, "Bob Phillips" wrote:
=A1&TEXT(A2,"mm/dd/yyyy") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message ups.com... im trying to concatenate a text and date cell. is this possible? i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh- Hide quoted text - - Show quoted text - sweet. thanks another question i have... how to merge cells conditionally??? is there such a thing as =if(A7=1,A7,MERGE(B1:B7)) Thanks, JB |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenating
Can't be done, and personally I think merged cells are more trouble than
they are worth. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message ups.com... On Feb 7, 1:35 pm, "Bob Phillips" wrote: =A1&TEXT(A2,"mm/dd/yyyy") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message ups.com... im trying to concatenate a text and date cell. is this possible? i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh- Hide quoted text - - Show quoted text - sweet. thanks another question i have... how to merge cells conditionally??? is there such a thing as =if(A7=1,A7,MERGE(B1:B7)) Thanks, JB |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenating
On Feb 7, 3:10 pm, "Bob Phillips" wrote:
Can't be done, and personally I think merged cells are more trouble than they are worth. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message ups.com... On Feb 7, 1:35 pm, "Bob Phillips" wrote: =A1&TEXT(A2,"mm/dd/yyyy") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message roups.com... im trying to concatenate a text and date cell. is this possible? i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh- Hide quoted text - - Show quoted text - sweet. thanks another question i have... how to merge cells conditionally??? is there such a thing as =if(A7=1,A7,MERGE(B1:B7)) Thanks, JB- Hide quoted text - - Show quoted text - how about conditionally bordering fo a group of cells? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenating
You can do that, but if it is a group, you have to have different condition
for top, right, etc., and you soon exhaust your three conditions. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message ups.com... On Feb 7, 3:10 pm, "Bob Phillips" wrote: Can't be done, and personally I think merged cells are more trouble than they are worth. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message ups.com... On Feb 7, 1:35 pm, "Bob Phillips" wrote: =A1&TEXT(A2,"mm/dd/yyyy") -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Yosh" wrote in message roups.com... im trying to concatenate a text and date cell. is this possible? i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh- Hide quoted text - - Show quoted text - sweet. thanks another question i have... how to merge cells conditionally??? is there such a thing as =if(A7=1,A7,MERGE(B1:B7)) Thanks, JB- Hide quoted text - - Show quoted text - how about conditionally bordering fo a group of cells? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
concatenating
=A1 & " " &TEXT(A2,"mm/dd/yyyy")
Assuming A1 is "Week Ending" and A2 is the date Gord Dibben MS Excel MVP On 7 Feb 2007 09:54:34 -0800, "Yosh" wrote: im trying to concatenate a text and date cell. is this possible? i.e. I have one cell that says: Week-ending And I have another cell: 01/26/2007 Can I concatenate to form: Week-ending 01/26/2007 The problem I have now is the formatting, it keeps taking the date and making it a number... (you know what I mean?) Thanks, Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Double quotes when concatenating with CHAR(10) | Excel Discussion (Misc queries) | |||
| Date column changed to number format while concatenating | Excel Discussion (Misc queries) | |||
| How do I start new line when concatenating text strings in excel? | Excel Discussion (Misc queries) | |||
| Concatenating text | Excel Discussion (Misc queries) | |||
| concatenating and formatting area code and phone number columns | Excel Worksheet Functions | |||
Hybrid Mode
