Text
This page presents procedures from class WorksheetFunction related to the theme Text
Arabic - Converts a Roman numeral to an Arabic numeral.
Asc - For double-byte character set (DBCS) languages, changes full-width (double-byte) characters to half-width (single-byte) characters.
BahtText - Converts a number to Thai text and adds a suffix of Baht.
Base - Converts a number into a text representation with the given radix (base).
Concat -
Dbcs - Converts half-width (single-byte) letters within a character string to full-width (double-byte) characters. The name of the function (and the characters that it converts) depends upon the language settings.
Decimal - Converts a text representation of a number in a given base into a decimal number.
Dollar - The function described in this Help topic converts a number to text format and applies a currency symbol. The name of the function (and the symbol that it applies) depends upon your language settings.
Find - Finds specific information on a worksheet.
FindB - Find and FindB locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
Fixed - Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
NumberValue - Converts text to number in a locale-independent manner.
Phonetic - Extracts the phonetic (furigana) characters from a text string.
Proper - Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Replace - Replaces part of a text string, based on the number of characters that you specify, with a different text string.
ReplaceB - Replaces part of a text string, based on the number of bytes that you specify, with a different text string.
Rept - Repeats text a given number of times. Use Rept to fill a cell with a number of instances of a text string.
Search - Search and SearchB locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
SearchB - Search and SearchB locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
Substitute - Substitutes new_text for old_text in a text string. Use Substitute when you want to replace specific text in a text string; use Replace when you want to replace any text that occurs in a specific location in a text string.
Text - Converts a value to text in a specific number format.
TextJoin -
Trim - Removes all spaces from text except for single spaces between words. Use Trim on text that you have received from another application that may have irregular spacing.
Unichar - Returns the Unicode character referenced by the given numeric value.
Unicode - Returns the number (code point) corresponding to the first character of the text.
USDollar - Converts a number to text format and applies a currency symbol. The name of the method (and the symbol that it applies) depends upon the language settings.