The cells the formula are in are formatted as text

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"CajnBred" wrote in message
...
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.