Previous Topic Next Topic

Comebiine multiple cells displays formula

Closed
Micky - Apr 6, 2010 at 02:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 6, 2010 at 03:37 PM

In Excel 2007
Very basic formula but I think it is a bug.

A1 has first name; B1 has last name; C1 has Company Name and D1 has title

E1 =A1&" "&B1&", "&C1&", "&D1

Result shows formula. if I go to excel options and remove all check marks on formulas it will then work fine. Another day I remove all check marks first and then do the formula and it doesn't work. I really don't want to loose all the check marks I just want the formula to display the combined text. I know the formula is ok...its the stupid 2007 program... any fix?

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 6, 2010 at 03:37 PM
Have you checked under

OFFICE BUTTON --> EXCEL OPTIONS --> ADVANCE

Under section "Display options for this worksheet", there is an option "Show formulas in cells instead of their calculated results". Make sure that it is not checked
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response