Concatenation problem

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

Hello,

I'm having a problem with the concatenation function and
I could use some help. Using the formula icon, I have
input =concatenate(A1,B1) because per my data below, I'd
like Joe Smith to appear in cell C1. Unfortunately, the
result in cell C1 is literally "concatenate(A1,B1)" and
not "Joe Smith."

Under tools->options, the show formulas box is not
checked. Both cell A1 and B1 are formatted as text. I
have also tried the formula =A1&B1 but that just yields
the same problem showing "=A1&B1." What makes this even
more confusing is that when I used the formula input box,
the input box showed a forumula result of Joe Smith even
though the actual output was =concatenate(A1,B1).

Example:
A1: Joe
B1: Smith

Thanks in advance for your help.
-Scott
 
Reformat C1 as General and reenter your formula. WHen a cell is
formatted as Text, XL's parser doesn't recognize an entry as a formula.
 
Back
Top