Sorry...I meant to say =CONCATENATE(A1,B1) and C1 will have nothing in it.

"Big UT Fan" wrote:

I can't seem to get concatenate to work. I've tried even very simple
attempts. Such as text in A1 and B1 and entering this function into C1
=CONCATENATE(A1, B1)/ C1 will have nothing in it. I try using
=CONCATENATE(TEXT(A1), TEXT(B1))...nothing. I try =A1 & B1 with the same
results...nothing. What am I doing wrong?