Anthony K O365
asked on
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!
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!
Here is the solution. http://www.techrepublic.com/blog/microsoft-office/office-solution-a-few-reasons-why-excel-formulas-might-not-calculate-as-expected/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was it!
Thank you.
Thank you.