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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validate data but then change the entry to upper case 4
Lower-Case Characters 2
In Excel, changing a range of cells to all caps. 2
Upper case to Lower case 5
filtering to separate upper & lower case 5
Change lower case to upper case 6
Upper to Lowercase in Excel 7
Caps Lock vs Lower Case 5

Top