concatenate function help
 

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

concatenate function help
 

Try this.

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


andresg1975 wrote:
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

concatenate function help
 

thanks a lot for your help

"willwonka" wrote:

Try this.

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


andresg1975 wrote:
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