concatenating

[Yosh]

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

 

[Guest]

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

 

[Bob Phillips]

=A1&TEXT(A2,"mm/dd/yyyy")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

=A1 & " " &TEXT(A2,"mm/dd/yyyy")

Assuming A1 is "Week Ending" and A2 is the date


Gord Dibben MS Excel MVP

 

[Yosh]

=A1&TEXT(A2,"mm/dd/yyyy")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)







- 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

 

[Bob Phillips]

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]

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)







- Show quoted text -

how about conditionally bordering fo a group of cells?

 

[Bob Phillips]

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)