How to convert any sentence directly from small letter to capital letter in MS-EXCEL?

Question

In MS-WORD I can easily convert the same by using Shift+F3 but not in MS-EXCEL, please help

Answer 1

Here is a macro that will change the selected cells to upper case.



Alt+F11 to open the VB editor

select Inset\Module

Paste the code below in the edit window

Select the cells you want to change and run the macro.







Sub UpperCase()

Dim Rng As Range

On Error Resume Next

Err.Clear

Application.EnableEvents = False

For Each Rng In Selection.SpecialCells(xlCellTypeConstants, _

xlTextValues).Cells

If Err.Number = 0 Then

Rng.Value = StrConv(Rng.Text, vbUpperCase)

' Rng.Value = StrConv(Rng.Text, vbLowerCase)

' Rng.Value = StrConv(Rng.Text, vbProperCase)

End If

Next Rng

Application.EnableEvents = True

End Sub

Answer 2

I think the best way is just to copy everything to MS word and then do it there and transfer back to excel

Answer 3

hi ,,,,



In excel using =upper(text) -> convert smaller to upper or captel letters

=lower(text) -> convert upper to lower letters



in word using select data and press the shift+F3

Answer 4

Hello manchu,



The following formula(s) will change the case to your desired case. Keep in mind, if you plan on using the converted case from the formula's, be sure to select the cell with the case converted and copy, then paste special Values in another cell.



To change case with a formula, insert a blank column next to the column whose case you wish to change. In that column enter one of the following formula's, depending on what case you want as the result. Change the reference A1 to the first cell in your range.



=UPPER(A1)

=LOWER(A1)

=PROPER(A1)



Exercise:

Make columns A, B, C a column width of 32

A1 Case

B1 Converted Case

C1 Paste Special (Values)

A2 lower to upper

B2 =UPPER(A2)

C2 Paste special (Values) from column B formulas

A3 UPPER TO LOWER

B3 =LOWER(A3)

C3 Paste special (Values) from column B formulas

A4 lower/upper TO sentence CASE

B4 = PROPER(A4)

C4 Paste special (Values) from column B formulas



Hope this helps,

d.tcom

Answer 5

try pressing Ctrl and } button at the sam time to enlarge and Ctrl and { to lower the font.

Answer 6

try highlighting the sentence, then clicking caps.