REPT function

CODE( ):
I have given here about the formula syntax and usage of the CODE function in Microsoft Excel.
 
Description:
Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.

Syntax:
CODE(text)
The CODE function syntax has the following arguments:
Text:    Required. The text for which you want the code of the first character.
 
Q:
How to use Code function to find the ASCII value for a character?
Type the function as follows in the cell that you would like to get the result in:
=CODE(“A”)
 
For more understanding, look at the screenshot please:

CHAR( ):
I have given here about the formula syntax and usage of the CHAR function in Microsoft Excel.
 
Description:
Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.
 
Syntax:
CHAR(number)
The CHAR function syntax has the following arguments:
Number    Required. A number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.
 
Note: Excel Online supports only CHAR(9), CHAR(10), CHAR(13), and CHAR(32) and above.
 
Q:
How to use Char function to find the character for ASCII value?
Type the function as follows in the cell that you would like to get the result in:
=CHAR(65)
 
For more understanding, look at the screenshot please:

REPT( ):
I have given here about the formula syntax and usage of the REPT  function in Microsoft Excel.

Description:
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.

Syntax:
REPT(text, number_times)
 
The REPT function syntax has the following arguments:
Text    Required. The text you want to repeat.
Number_times    Required. A positive number specifying the number of times to repeat text.
 
Remarks:
If number_times is 0 (zero), REPT returns "" (empty text). If number_times is not an integer, it is truncated. The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!.
 
Q:
How to use REPT function to repeat the characters of time is given?
Type the function as follows in the cell that you would like to get the result in:
=REPT("a",5)

For more understanding, look at the screenshot please: