Thread: Excel: How do I change all upper case ss to proper case?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Excel: How do I change all upper case ss to proper case?
Use another spreadsheet. In A1 type
=PROPER(
switch spreadsheets and click on A1 of the original. Then close
parentheses. Copy throughout. Then, the get rid of formulas,
Copy everything, Edit!Paste Special... and check Values.

HTH
Kostis Vezerides

Reply With QuoteReply With Quote