• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

Results of formula doesn't show in Excel

I am totally perplexed. Excel spreadsheet with three columns.  Column B has last name and column C has first name.  I want to concatenate those to into last, first.
Here is the confusion.  I know the formula and here is what is in the cell.
=CONCATENATE(B2,", "+C2)
That produces exactly that:
=CONCATENATE(B2,", "+C2) and not the results of the formula.  As I build it using the "Insert Function" button I can see the results is what I want but when I press enter only the formula shows.  I build it from scratch by typing all in and get the same.  What am I missing?
Formatting?  Is so what?
Thanks in advance.
Marvin
0
mabarnes11
Asked:
mabarnes11
  • 2
1 Solution
 
Steven HarrisPresidentCommented:
You type in a formula and you see the formula, not the results?  Open the sheet and press CTRL + ` (grave accent)
0
 
mabarnes11Author Commented:
Thanks!!!
0
 
Steven HarrisPresidentCommented:
Glad you got it!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now