& "comment"

  • Thread starter @Homeonthecouch
  • Start date
@

@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
 
D

Dave Peterson

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

@Homeonthecouch said:
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
Click to expand...
 
@

@Homeonthecouch

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

LOL

Thank you very much

Andrew
 
D

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")
 
B

Beege

@Homeonthecouch said:
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
Click to expand...

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
 
Top