How to use CHAR Formula in Excel

In this video, learn how to use CHAR Formula in Excel. The CHAR formula in Excel returns the character based on a number. The CHAR formula in Microsoft Excel gives the alphabet, character or symbol based on the number.

Subscribe Rath Point YouTube Channel:

★★ TIMER ★★

Skip to 00:00 Char Formula in Excel
Skip to 00:31 Char List
Skip to 01:10 Excel Char Function Example 1
Skip to 02:12 Char Numbers
Skip to 02:46 Excel Char Function Example 2

★★ How to use Excel Char Function ★★

Syntax of CHAR Function:
=CHAR(number)

Arguments of CHAR function:

Number (Required Argument) – A number from 1 to 255 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255) to return the character.

Macintosh: Macintosh character set

Windows: ANSI (American Standard Code for Information Interchange) character set.

★★ MS Excel Tutorial ★★

★★ MS Word Tutorial ★★

★★ PowerPoint Tutorial ★★

★★ Learn More Excel Formulas and Functions ★★

★★ PLAYLIST ★★

★★ SUBSCRIBE, LIKE, SHARE & COMMENT ★★

SUBSCRIBE: Please subscribe to our channel for more useful videos.
LIKE: If you like the video then please hit the like button.
SHARE: Feel free to share with your friends and family in social networks to improve their knowledge.
COMMENT: Your comment will motivate us to add more and more videos and will resolve your queries.

★★ CONNECT with Rath Point ★★

Subscribe Rath Point:

★★ THNAK YOU ★★

Thanks for watching Rath Point YouTube Channel.

[rathpoint]

SUBSCRIBE: Please subscribe to our channel for more useful videos.

LIKE: Please hit the like button.

SHARE: Feel free to share with your friends and family in social networks to improve their knowledge.

COMMENT: Your comment will motivate us to add more and more videos and will resolve your queries.