concatenate values
 

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?

concatenate values
 

Try hitting CTRL+~

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

"Flint springs" wrote:

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?

concatenate values
 

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


"Flint springs" wrote:

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?

concatenate values
 

"Flint springs" <Flint wrote:
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 -----

"Flint springs" <Flint wrote in message
...
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?

concatenate values
 

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

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?