& "comment"

[@Homeonthecouch]

Hello
Is it possible to use the & "Comment" before a formula?

e.g.
=DATEDIF(A5,NOW(),"md")& " Days"

Is it possible to put the horse before the cart?

any help is as always appreciated.

Andrew

 

[Dave Peterson]

="Days " & DATEDIF(A5,NOW(),"md")

Hello
Is it possible to use the & "Comment" before a formula?

e.g.
=DATEDIF(A5,NOW(),"md")& " Days"

Is it possible to put the horse before the cart?

any help is as always appreciated.

Andrew

 

[@Homeonthecouch]

Oh blimey that has to be the only way round i didnt try !!!!!

LOL

Thank you very much

Andrew

 

[Dave Peterson]

If you come back...

Sometimes, you may want to concatenate a date or a formatted number:

="The amount you owe is: " & text(a1,"$0.00")
or
="It's due on: " & text(a1, "mmmm dd, yyyy")

 

[Beege]

Hello
Is it possible to use the & "Comment" before a formula?

e.g.
=DATEDIF(A5,NOW(),"md")& " Days"

Is it possible to put the horse before the cart?

any help is as always appreciated.

Andrew

Andrew,

The ampersand (&) is the character that says "join these together", so
if you have A in A1, B in C3 and =A1&C3 somewhere else, you will see AB
as the result. Likewise, if you have ="Time_"&"is_"&"up" in a cell, the
result will be Time_is_up in the cell. Hope this makes it clearer.

Beege