Text Header

[robert030975]

how do you put text before the value??


eg if a cell has

=<day> it would display Thursday

I would like to put
Today is Thursay

its easy to do it after as you just =<day>+ " blalblah"

 

[skrandel]

I take it you have tried:

="Today is " + <day>

Are you getting a error. This is how I do it all the time.

Steve Krandel
Symantec

 

[robert030975]

Cheers Steve

yup having a stupid day!