Excel Functions

Returns character against character code

Removes non printable characters

Returns numeric code for a given character

Joins two or more text strings from different ranges into a single text string

Joins two or more text strings into a single text string

Converts a number to text using a currency format

Compare two text strings and returns TRUE if matches

Returns position of character or sub-string in a text string, it’s case sensitive

Converts a number to text with required umber of decimal places

Returns one or more characters from the beginning of the text string

Returns length of the text string

Converts the text string into lower case

Returns the number of characters from a text string as specified, starting from the specified place

Converts a number in text format to number with decimal separator and group separator as specified

Converts first character of text string into upper case and balnace to lower case

Replaces one or more characters of a text string with different text string

Repeats text specified number of times

Returns one or more characters from the end of the text string

Returns position of character or substring in a text string, it’s not case sensitive

Substitutes one or more characters of a text string with new text string

Returns text for text value and empty string for number, date and logical values

Converts a value into text in the specified format

Joins two or more strings with a delimiter and can ignore empty values

Removes extra spaces except single space between words

Returns a unicode character against given number

Returns numeric code for a given unicode character

Converts the text string into upper case

Converts a number in the text format to number