Saurabh Jain
-
Posts
1,726 -
Joined
-
Last visited
-
Days Won
61
Content Type
Profiles
Forums
Gallery
Downloads
Blogs
Events
Online Conference
The Excel dictionary
Power Query M function dictionary
Everything posted by Saurabh Jain
-
Formats a number and converts it to text
-
Converts its arguments to text
-
Substitutes new text for old text in a text string
-
Finds one text value within another (not case-sensitive)
-
Returns the rightmost characters from a text value
-
Repeats text a given number of times
-
Replaces characters within text
-
Capitalizes the first letter in each word of a text value
-
Extracts the phonetic (furigana) characters from a text string
-
Converts text to number in a locale-independent manner
-
Returns a specific number of characters from a text string starting at the position you specify
-
Converts text to lowercase
-
Returns the number of characters in a text string
-
Returns the leftmost characters from a text value
-
Formats a number as text with a fixed number of decimals
-
Finds one text value within another (case-sensitive)
-
Checks to see if two text values are identical
-
Converts a number to text, using the $ (dollar) currency format
-
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
-
Joins several text items into one text item
-
Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
-
Returns a numeric code for the first character in a text string
-
Removes all nonprintable characters from text
-
Returns the character specified by the code number
-
Converts a number to text, using the ß (baht) currency format
