REPLACE, UNICHAR, UNICODE FUNCTIONS

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

Description
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Syntax
REPLACE(old_text, start_num, num_chars, new_text)

The REPLACE function syntax has the following arguments:
Old_text    Required. Text in which you want to replace some characters.
Start_num    Required. The position of the character in old_text that you want to replace with new_text.
Num_chars    Required. The number of characters in old_text that you want REPLACE to replace with new_text.
New_text    Required. The text that will replace characters in old_text.

Q:
How to use Replace function to copy the text with replacement of the word?
Type the function as follows in the cell that you would like to get the result in:
=REPLACE(A2,7,5,”Roshi”)

For more understanding, look at the screenshot please:

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

Description:
Returns the Unicode character that is referenced by the given numeric value.

Syntax:
UNICHAR(number)
The UNICHAR function syntax has the following arguments.
Number    Required. Number is the Unicode number that represents the character.

Remarks:
The Unicode character that is returned can be a string of characters, for example in UTF-8 or UTF-16 codes. And if Unicode numbers are partial surrogates and data types that are not valid, UNICHAR returns the #N/A error value.
If numbers are numeric values that fall outside the allowable range, UNICHAR returns the #VALUE! error value. And if number is zero (0), UNICHAR returns the #VALUE! error value.

Q:
How to get Unicode Character for number 97 by using UNICHAR( ) function?
Type the function as follows in a cell that you would like to get the result in:
=UNICHAR(97)

For more understanding, look at the screenshot please:

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

Description:
Returns the number (code point) corresponding to the first character of the text.

Syntax:
UNICODE(text)
The UNICODE function syntax has the following arguments.
Text    Required. Text is the character for which you want the Unicode value.

Remarks:
If text contains partial surrogates or data types that are not valid, UNICODE returns the #VALUE! error value.
 
Q:
How to get Unicode Number for Character “A” by using UNICODE( ) function?
Type the function as follows in a cell that you would like to get the result in:
=UNICODE(“A”)
 
For more understanding, look at the screenshot please: