Find solution
How to convert capital letters to small letters in MS excel?

Does anyone know how to convert a Excel spreadsheet form all cap letters to proper letters?

  • Answer:

    If this was MS-Access, then a simple Query could handle this in a matter of seconds. But you will need to have a VBA coded Macro established to search through your worksheet and modify the cells to proper-case. Option Explicit Public rngVar As Object Public Sub Build_Format() For Each rngVar In [A1:Z999] rngVar.Value = Proper(rngVar.Value) Next End Sub .

Kristal H at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

Let's say you want to convert text from uppercase to lowercase or from lowercase to proper case to make it more readable. To change the case of text, use the UPPER, LOWER, or PROPER functions. Example The example may be easier to understand if you copy it to a blank worksheet. How to copy an example Create a blank workbook or worksheet. Select the example in the Help topic. Note Do not select the row or column headers. Selecting an example from Help Press CTRL+C. In the worksheet, select cell A1, and press CTRL+V. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button. 1 2 A Name nancy Davolio Formula Description (Result) =UPPER(A2) Changes text to all UPPERCASE (NANCY DAVOLIO) =LOWER(A2) Changes text to all lowercase (nancy davolio) =PROPER(A2) Changes text to Title Case (Nancy Davolio)

kayy

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.