Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

---

Convert Numbers İn Cells To Letters

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php lgili hücreleri seçtikten sonra; Kod: Sub Encrypt2() Dim Array1, Array2 Dim i As Integer Dim MyRng As Range Array1 = Array("a", "N", "b", "t", "S", "E", "T", "K", "I", "Z") Array2 = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 0) For Each MyRng In Selection For i = LBound(Array1) To UBound(Array1) MyRng = WorksheetFunction.Substitute(MyRng, Array1(i), Array2(i)) Next Next End Sub ' Sub Decrypt2() Dim Array1, Array2 Dim i As Integer Dim MyRng As Range Array1 = Array("a", "N", "b", "t", "S", "E", "T", "K", "I", "Z") Array2 = Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 0) For Each MyRng In Selection For i = LBound(Array1) To UBound(Array1) MyRng = WorksheetFunction.Substitute(MyRng, Array2(i), Array1(i)) Next Next End Sub

Report problem with this macro

This macro does not work.
There's an error in the code.
Other
You can write your comments about the error in the box below.

Report error

ALL MACROS Youtube Channel
The following macros may be useful for you.

Similar Results

No	Macro Name
1	convert numbers in cells to letters
2	excel operators hk
3	separates the text in the active cell into letters (columns)
4	divides the text in the active cell into letters (divided by 3 characters into columns)
5	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.
6	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.
7	convert formulas to numbers
8	convert formulas to numbers
9	Converting column letters to column numbers
10	convert
11	converts the number in the cell to lower or upper case and normal. h2o co2
12	Convert Day to Day: if you have a date on your worksheet and want to convert all these dates into days, this code is for you. Just select the range of cells and run this macro.
13	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.
14	separates numbers from letters and numbers in a column
15	convert double and single lines into different colors and designs (one line is bold and the other line is normal)
16	Convert Roman Numbers to Arabic Numbers: Sometimes it is really hard to understand Roman numbers as serial numbers. This code will help you convert roman numbers to Arabic numbers.
17	Converting to Suitcase: And this code converts the selected text into the correct word that fills the first letter of capital with lowercase letters.
18	converts text to uppercase & lowercase
19	converts text to uppercase & lowercase
20	Specifies the converted cells that converts uppercase to lowercase. (Toggle)

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses