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

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

  • Answer:

    Though you could use the LOWER function in a formula, that does not do much good when you wish to convert the text in a large number of cells on a spreadsheet to lowercase. A better approach is to create a Macro that you can easily use from the TOOLS ==> MACROS menu options or by assigning a custom toolbar icon to the Macro. Here is that Macro: Public Sub LowerCase() Dim rng As Range Dim cell As Range Set rng = ActiveWindow.RangeSelection For Each cell In rng cell.Value = StrConv(cell.Value, vbLowerCase) Next cell End Sub The above will work for only those cells that are selected at the time you run the Macro. If you want the Macro to select all cells that have data around the current active cell, then replace the above SET statement with the following: Set rng = ActiveCell.CurrentRegion .

debajit d at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

That's right. capital -> small is "lower" small -> capital is "upper"

I think that is not possible in excel but in word it is possible write any word and after that select that word and press ctrl+shift+A key. i think it work or help you some.

Soman

I would use: =PROPER(A1) or whatever your cell that has capital letters in it. The Proper function will keep the first letter capitalized.

4W350M3-0

Use the lower() function A1: TITLE B1: =lower(A1) The value that would show in B1 is title For immediate help go to http://www.crossloop.com/PCS_Help

PCS_Help

use "change case" icon from Tool bar

goodguy

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.