converts the number in the cell to lower or upper case and normal. h2o co2 Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
 
Sub ZahlHoch()
   Dim r As Range
   Dim i As Integer
   For Each r In Selection.Cells
      If r.Value  Empty Then
         For i = 1 To Len(r.Value)
            If IsNumeric(Mid(r.Value, i, 1)) Then
               r.Characters(i, 1).Font.Superscript = True
            Else
               r.Characters(i, 1).Font.Superscript = False
            End If
         Next
      End If
   Next
End Sub
Sub ZahlTief()
   Dim r As Range
   Dim i As Integer
   For Each r In Selection.Cells
      If r.Value  Empty Then
         For i = 1 To Len(r.Value)
            If IsNumeric(Mid(r.Value, i, 1)) Then
               r.Characters(i, 1).Font.Subscript = True
            Else
               r.Characters(i, 1).Font.Subscript = False
            End If
         Next
      End If
   Next
End Sub
Sub ZahlNormal()
   Dim r As Range
   Dim i As Integer
   For Each r In Selection.Cells
      If r.Value  Empty Then
         For i = 1 To Len(r.Value)
            If IsNumeric(Mid(r.Value, i, 1)) Then
               r.Characters(i, 1).Font.Superscript = False
               r.Characters(i, 1).Font.Subscript = False
            End If
         Next
      End If
   Next
End Sub

No	Macro Name
1	converts the number in the cell to lower or upper case and normal. h2o co2
2	excel operators hk
3	Specifies the converted cells that converts uppercase to lowercase. (Toggle)
4	Convert Small Case: This code helps you convert selected text to lower case text. & Nbsp; Select a range of cells that contain your text and run this code. If a cell has any value other than a number or text, the value will remain the same.
5	converts text to uppercase & lowercase
6	converts text to uppercase & lowercase
7	selects full cells and converts them to lower case
8	selects full cells and converts them to uppercase
9	Convert selected cells to uppercase or lowercase with one click
10	Convert to Uppercase: Select cells and run this code. Checks each cell of the selected range and then converts it to uppercase text.
11	translate the number / number into English (in dollars and cents)
12	Converting Number / Number to Text Function (Turkish)
13	automatic image fetch
14	saves data
15	Square Root Calculator: You can use this code to calculate the square root without applying a formula. checks all selected cells and converts numbers to square.
16	Calculate Cube Root: You can use this code to calculate the cube root without applying a formula. Checks all selected cells and converts numbers to cube roots.
17	just enter numbers in the color cell: msgbox
18	convert double and single lines into different colors and designs (one line is bold and the other line is normal)
19	Find and select the remaining cell in the value between 2 selected numbers
20	find-change-delete-save macro

Excel Free Macros (VBA)

Converts The Number İn The Cell To Lower Or Upper Case And Normal. H2o Co2

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords