अगर आप Microsoft Excel चलाते है या फिर इक्सेल को चलना सीख रहे है ये पोस्ट आपके लिए ही है, क्योंकि मे आपके लिए कुछ MS Excel Text Functions हिन्दी मे ले कर आया हु, जोकी आपको बहुत काम आने वाले है।
MS Excel Text Function in Hindi
अगर आप Ms Excel मे Accounts या कोई ऐसा काम करते है जहा Text या Insurance को ले के excel sheet बनानी पड़ती है तो नीचे दिए गए Text Function आपके काम को बहुत ही आसान बना सकते है।
Function | Description |
---|---|
ARRAYTOTEXT function | Returns an array of text values from any specified range |
ASC function | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |
BAHTTEXT function | Converts a number to text, using the ß (baht) currency format |
CHAR function | Returns the character specified by the code number |
CLEAN function | Removes all nonprintable characters from text |
CODE function | Returns a numeric code for the first character in a text string |
CONCAT function | Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments. |
CONCATENATE function | Joins several text items into one text item |
DBCS function | Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
DOLLAR function | Converts a number to text, using the $ (dollar) currency format |
EXACT function | Checks to see if two text values are identical |
FIND, FINDB functions | Finds one text value within another (case-sensitive) |
FIXED function | Formats a number as text with a fixed number of decimals |
LEFT, LEFTB functions | Returns the leftmost characters from a text value |
LEN, LENB functions | Returns the number of characters in a text string |
LOWER function | Converts text to lowercase |
MID, MIDB functions | Returns a specific number of characters from a text string starting at the position you specify |
NUMBERVALUE function | Converts text to number in a locale-independent manner |
PHONETIC function | Extracts the phonetic (furigana) characters from a text string |
PROPER function | Capitalizes the first letter in each word of a text value |
REPLACE, REPLACEB functions | Replaces characters within text |
REPT function | Repeats text a given number of times |
RIGHT, RIGHTB functions | Returns the rightmost characters from a text value |
SEARCH, SEARCHB functions | Finds one text value within another (not case-sensitive) |
SUBSTITUTE function | Substitutes new text for old text in a text string |
T function | Converts its arguments to text |
TEXT function | Formats a number and converts it to text |
TEXTAFTER function | Returns text that occurs after given character or string |
TEXTBEFORE function | Returns text that occurs before a given character or string |
TEXTJOIN function | Combines the text from multiple ranges and/or strings |
TEXTSPLIT function | Splits text strings by using column and row delimiters |
TRIM function | Removes spaces from text |
UNICHAR function | Returns the Unicode character that is references by the given numeric value |
UNICODE function | Returns the number (code point) that corresponds to the first character of the text |
UPPER function | Converts text to uppercase |
VALUE function | Converts a text argument to a number |
VALUETOTEXT function | Returns text from any specified value |
MS Excel Text Functions PDF Download
MS Excel Text Function की PDF को डाउनलोड करना चाहते है तो हमारे Telegram Group से जुड़ कर आसानी से Excel Pdf को अपने मोबाईल computer मे डाउनलोड कर सकते है।
हमने यहा पर लगभग सभी MS Excel के Text के Functions को हिन्दी मे इस लिस्ट मे समिल किया है, अगर आपके पास कोई Function है जोकी इस लिस्ट मे समिल हो सके तो हमे Comment मे बताए।
- MS Excel Logical Functions PDF List Download
- MS Excel Compatibility Functions List PDF Download
- MS Excel Engineering Functions List PDF Download
- MS Excel Statistical Functions List PDF Download
- MS Excel Text Functions List PDF Download
- MS Excel Financial Functions List PDF Download
- MS Excel Database Functions in Hindi
- MS Excel Date and Time Functions
- MS Excel Web Functions PDF Download
- MS Excel Lookup and Reference Functions List PDF Download
- MS Excel Math and Trigonometry Functions List PDF Download