"proper" function excel wksht

C

CajnBred

Why would the "proper" funtion for capitalizing work on some columns of my
worksheet and not on others. Some display the proper Capitalized text, other
columns just display the formula. Using same formula in both places.
 
G

Gord Dibben

Most likely cause is that the "some" columns were pre-formatted as text which
will make the formulas text.

Select one of these and F2 then ENTER to see if results change.

If you have many of these to do use Edit>Replace.

Select all cells and Edit>Replace

What: =
With: =

This coerces the text to real formulas.


Gord Dibben Excel MVP
 
Top