UNICODE Characters

ANSI was then extended to include additional numbers (256 - 65,535)
The UNICODE character set is a universal standard across all systems.
The first 128 characters of Unicode are the same as the 128 characters of ASCII.
The first 255 characters of Unicode are the same as the first 255 characters of ANSI.
UTF8
UTF16
ASCW - Returns the Unicode number for the first character in a text string.
CHRW - Returns the character with the corresponding Unicode number.


Hexadecimal

space%20:%3AT%54n%6E
!%21;%3BU%55o%6F
"%22<%3CV%56p%70
#%23=%3DW%57q%71
$%24>%3EX%58r%72
%%25?%3FY%59s%73
&%26@%40Z%5At%74
'%27A%41[%5Bu%75
(%28B%42\%5Cv%76
)%29C%43]%5Dw%77
*%2AD%44^%5Ex%78
+%2BE%45_%5Fy%79
,%2CF%46`%60z%80
-%2DG%47a%61{%81
.%2EH%48b%62|%82
/%2FI%49c%63}%83
0%30J%4Ad%64~%84
1%31K%4Be%65  
2%32L%4Cf%66  
3%33M%4Dg%67  
4%34N%4Eh%68  
5%35O%4Fi%69  
6%36P%50j%6A  
7%37Q%51k%6B  
8%38R%52l%6C  
9%39S%53m%6D  

ASCW Bug

This returns the bit pattern for unsigned 16-bit integers.
VBA uses signed 16-bit integers so after 32767 this function will return negative numbers.
Use the following function instead

Public Function ASCW_2(ByVal sChar As String) As Integer 
   ASCW_2 = (ASCW(sChar) And &HFFF&)
End Function

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext