concatenate function help

[Guest]

i have two columns, lets say

column b c d
any row blank deposit date 09/12/06

how can i concatenate these two columns so that they will appear in column b
as
"deposit date 09/12/06".
I try using the concatenate function but it brings "deposit date38972", i
would like to have a space between "deposit date" and 09/12/06 and not show
me the date number 38972, i want it exactly as 09/12/06.
thanks for your help

 

[willwonka]

Try this.

=c1&" "&text(d1,"mm/dd/yy")

 

[Guest]

thanks a lot for your help

Try this.

=c1&" "&text(d1,"mm/dd/yy")