|
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 |
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 |
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 |
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 |
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 |
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 |
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? |
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? |
| All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com