[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

Excel 2013 Formula not converting

Hello,

I'm using Office 2013 and Excel is not converting my formula to the value. For example:

A1, B1
Doe, John

When I do =A1&", "&B1 in cell C2, I'm expecting Doe, John. However I get =A1&", "&B1. It is not select the values in cell A1 and B1. This worked fine in Office 2010. What is the correction?


Thanks!
0
Anthony K O365
Asked:
Anthony K O365
1 Solution
 
helpfinderCommented:
just right click C2, select Format Cells and make it General. Then enter C2 cell (double click or F2) and press ENTER
You see formula in C2 and not Values probably because C2 is formatted as Text
0
 
Anthony K O365Author Commented:
That was it!

Thank you.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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