Change from mixed caps and upper lower to all upper lower case

F

Fish''s Mermaid

I have ever changing data base that imports as both mixed upper/lower and all
caps. I want to change all text to initial caps. Any formula in EXCEL to do
this?
 
V

vezerid

In a new column:

=PROPER(A1)

Later, if you want, you can copy the formula column and Edit|Paste
Special...|Values, you can paste the values over the original column.

HTH
Kostis Vezerides
 
Top