The Excel CONCATENATE function is a powerhouse when it comes to combining text strings and data in your spreadsheets. It allows you to merge or concatenate multiple text strings into a single cell, making it a valuable tool for creating …
Lesson#234: Excel CONCATENATE Function: Merging Text with Precision Read more →
Here I shall show you to make alphabet numbering formula. Like A, B, C, D…. or a, b, c, d…. Before starting that I want you to memorise that in ASCII code A starts from 65 and a starts from …
Lesson#154: How to make Alphabet numbering formula in Excel Read more →
CODE is the opposite of the CHAR function. The syntax of this function is CODE(text). It will return the ASCII value of the first character of the text. I have shown in the above pictures how an ASCII table is …
The CHAR function returns the relevant character from the ASCII code. The syntax of the function is CHAR (number) where the number should be within 1 to 255. Example: Related video tutorials: