TEXT & FORMATTING FUNCTIONS
The Text & formatting functions are mostly required for string handling in Excel Datasets . The Excel text Functions is used to convert numbers to text within the spreadsheet . Text is available in all versions of Excel . We use this function in the circumstances , when we want to display dates in a specified format , when we wish to display numbers in a specified format or in a more legible way or when we wish to combine numbers with text or characters .
Text functions
There are total 28 Text & Formatting functions in MS Excel .These 28 Text & Formatting functions are given below :
1.) BAHTTEXT : Converts a number to text ( baht) .
2.) CHAR : Returns the character specified by the code number from the character set for your computer .
3.) CLEAN : Removes all nonprintable characters from the text .
4.) CODE : Returns a numeric code for the first character in a text string , in the character set used by your character .
5.) CONCAT : Concatenates a list or range of text strings .
6.) DOLLAR : Converts the number into text , using currency format .
7.) EXACT : Checks whether two text strings are exactly the same , and returns TRUE or FALSE . Exact in case sensitive .
8.) FIND : Returns the starting position of one text string within the another text string . FIND in case sensitive .
9.) FIXED : Rounds a number to the specified number of decimals and returns result as text with or without commas .
10.) LEFT : Returns the specified number of characters from a start of a text string .
11.) LEN : Returns the number of characters in a text string . Text is the whose length you want to find . Spaces count as characters .
12.) LOWER : Converts all letters in a text string to lowercase . Text is text you want to convert to lowercase . Characters in text that are not letters are not changed .
13.) MID : Returns the character from the middle of a text string , given a starting position and length . Text is the text string from which you want to extract the characters .
14.) NUMBERVALUE : Converts text to number in a locale - independent manner .
15.) PROPER : Converts a text string to proper case , the first letter in each word to uppercase and all other letters to lower case .
16.) REPLACE : Replaces part of a text string with a different text string . Old_text is text in which you want to replace some characters .
17.) REPT : Repeats text a given number of times . Use REPT to fill a cell with number instances of a text string .
18.) RIGHT : Returns the specified number of characters from the end of text string .
19.) SEARCH : Returns the number of the character at which the specific character or text string is first found , reading left to right ( not case - sensitive ) .
20.) SUBSTITUTE : Replace existing text with new text in a text string .
21.) T : Checks whether a value is text , and returns the text if it is , or returns the double quotes ( empty text ) if it is not .
22.) TEXT : Converts a number to text in a specific number format .
23.) TEXTJOIN : Concatenates a list or range of text strings using delimeter .
24.) TRIM : Removes all spaces from a text string except for single spaces between words .
25.) UNICHAR : Returns the unicode character referenced by the given numeric value .
26.) UNICODE : Returns the number ( code point ) corresponding to the first character for the text .
27.) UPPER : Converts the text string to all uppercase letters .
28.) VALUE : Converts a text string that represents number to a number .
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=Text Functions in Excel | Text formulas |Microsoft Excel |){kind=link}
0 Comments