In Short: This function returns the ANSI (American National Standard Institute) code of the number provided.
Explained:
Every character used by our computer, in general, and Microsoft Excel, in particular, has a specific number assigned to it. Microsoft makes use of ANSI codes that are set by an American private non-profit organization (ANSI Website). Out of these from 32 to 126 are taken from ASCII set.
Explained:
Every character used by our computer, in general, and Microsoft Excel, in particular, has a specific number assigned to it. Microsoft makes use of ANSI codes that are set by an American private non-profit organization (ANSI Website). Out of these from 32 to 126 are taken from ASCII set.
Below is a screen shot where we have entered four examples to replicate the working of "CHAR" function.
Moreover, for complete list of ANSI function supported please visit Microsoft Developer network Here
No comments:
Post a Comment