CHRW

CHRW(charcode)

Returns the character with the corresponding Unicode number (Variant / String)

charcode

The number that identifies a character (Long).

REMARKS

* This function can be used to return both printable and unprintable characters.
* Numbers from 0 - 31 are the same as standard, nonprintable ASCII codes.
* The normal range for number is 0 - 65,535.
* You can use the ASC function to return the ASCII / ANSI number for the first character in a text string.
* You can use the ASCW function to return the Unicode number for the first character in a text string.
* You can use the CHR function to return the character with the corresponding ASCII / ANSI number.
* You can use the CHRW$ function return a String data type instead of a Variant data type.
* The equivalent Excel function is Application.WorksheetFunction.CHAR
* The equivalent .NET function is Microsoft.VisualBasic.Strings.Chr
* For more information, refer to the Unicode Characters page.
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print ChrW(9)          '= tab  
Debug.Print ChrW(10)         '= line feed  
Debug.Print ChrW(13)         '= carriage return  
Debug.Print ChrW(32)         '= space  
Debug.Print ChrW(65)         '= "A"  
Debug.Print ChrW(70)         '= "F"  
Debug.Print ChrW(90)         '= "Z"  
Debug.Print ChrW(97)         '= "a"  
Debug.Print ChrW(122)        '= "z"  
Debug.Print ChrW(AscW("A"))  '= "z"