![]() ![]() This would return the following text string: I) Carefully notice the formulas in F column.Įxample 03: To introduce special characters or symbols in a text strings, try the MS Excel CHAR function: Let's move on to some important examples to illustrate the extensive use of CHAR function in MS Excel: Example 01: If you would like to merge information from multiple cells into one cell including 'new line', you could use CHAR(10) in the below manner using either of the CONCATENATE function or '&' operator. ii) CODE function in MS Excel is inverse of CHAR function. The behavious of CHR function in VBA is analogous to CHAR function in MS Excel. ¢ - Cent symbol comes from CHAR(162) Please note that i) CHR function in VBA is equivalent to CHAR function in MS Excel. ¤ - Generic Currency comes from CHAR(164) *, ( and ).ġ69 - Copyright Symbol © Currency Symbols: Some important ASCII codes helpful in MS Excel:ģ3 to 41 - Special Characters above numbers on keyboard i.e. (Source: Microsoft Office Help)įor example: CHAR(65) would return the alphabet A, similarly CHAR(10) would return new-line. Use CHAR to translate code page numbers you might get from files on other types of computers into characters. CHAR function: Returns the character specified by a number.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |