concatenate values

[Flint springs]

Working with Excel, I am trying to merge text from two columns into one
(first and last names). I've used two strategies: =A1," ", &B1
and=concatenate(A2, " ",A3). In both cases, all I see in the cell is the
formula, not the resulting name. When I use the concatenate function, the
correct name shows in the Function Arguments window in which I do the work.
How do I get this resulting name to actually show up in the cell?

 

[Sean Timmons]

Try hitting CTRL+~

Sounds like you are just viewing formulas instead of values...

 

[Eduardo]

Hi,
in excel 2007
Formulas,Formula auditing, click in show Formulas

 

[JoeU2004]

Working with Excel, I am trying to merge text from two columns into one
(first and last names). I've used two strategies: =A1," ", &B1

The correct formula is:

=A1&" "&B1

and =concatenate(A2, " ",A3). In both cases, all I see in the cell is the
formula, not the resulting name.

Sounds like the cell was formatted as Text before you entered the formula.
Change the format to General, then press F2 and Enter to cause the formula
to be evaluated.


----- original message -----

 

[Gord Dibben]

You are either in "View Formulas" mode or the cell was pre-formatted as
text.

Hit CTRL + '(backquote above Tab key) to toggle the formula view.

If no joy, format to General then F2 and ENTER


Gord Dibben MS Excel MVP

On Fri, 22 May 2009 07:42:35 -0700, Flint springs <Flint