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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top