Concatenation problems

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

I'm trying to concatenate two columns with a function, with the results
in a third column. I'm entering everything correctly, but I'm not
getting an answer...instead I'm getting the phrase
"=CONCATENATE(G13,H13)" in the cell, which is the equation I'm using in
the first place, not it's result. Is there a setting I must change or
something in order to see the actual answer?

Thanks,
Aaron
 
It sounds like the cell is formatted as text. Format it as general and re-enter
your existing formula.

(If you've already filled the column with similar formulas, you can format as
general and edit|replace = with =.)

Another cause could be that you have a space in front of the = sign "
=concatenate()"

===
I find typing:

=g13&h13

quicker (for what it's worth).
 
aaron

lose the quotes "..."

=CONCATENATE(G13,H13)

or you could use:

=G13&H13

Regards

Trevor
 
You might accidentally be in Formula view ?

Try pressing CTRL + ~
[ ~ is the tilde key, just above Tab key, to the left of "1" key ]

This key combo toggles the Formula view on / off
Just hit the key combo again to toggle it back to off.

Or, click Tools > Options > View tab
Under "Window options" - ensure "Formulas" is unchecked > OK
 
Back
Top