concatenate values

F

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?
 
S

Sean Timmons

Try hitting CTRL+~

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

JoeU2004

Flint springs said:
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 -----
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top