excel'03 how to convert a column from upper case to proper case

K

Ken Wright

Assume data in Col A. Use Col B as a helper Column, then use = PROPER(A2)
and copy down. Copy Col B and paste special as values over Col A. You can
now delete Col B.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 

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

how do i add new sheets to an exsisting formula 6
If then statement to search for text possible? 6
.xls file recieved,Do I have to download all of exel to read it 0
How do I change from upper case to proper case in excel 2002 9
can excell convert a file from 'works'? 0
How can you convert the false/true into 1/0 in Excel? 1
How do you freeze initial columns to appear on each page printed? 0
How can I change dollar sybbol to euro symbol? 2

Top