The ACCRINT Function
It calculates the accrued interest for a security that pays periodic interest.
It calculates the accrued interest for a security that pays periodic interest.
It converts a text that represents a number to that number.
It converts all the text to uppercase.
Removes all the spaces from the text except the single spaces between words.
It converts numbers to a more readable text format, using format codes. It will convert numbers to text, so functions that require a numeric value will not be able to use the converted one.
It returns a text referred by a given value.
It searches for a specific text in string and replaces it with another. It is a case-sensitive function.
It returns a given amount of characters from the end of a string.
It repeats a specific text a given number of times.
It replaces part of a string, based on a start position and number of characters you specify, with a different string.