Text and String Functions in Excel
List of Text and String Functions in Excel
String Functions in Excel are the used to manipulate strings in excel. This is particularly useful as databases not only consists of numeric entries but also string entries. String Functions in excel helps to organize the strings in a particular format on which analyst can perform various analysis.
Top String Functions in Excel discussed here are as follows -
- How to CONCATENATE Strings in Excel?
- How to manipulate TEXT in excel
- How to capitalize the text in excel using PROPER function
- Usage of MID, LEFT and RIGHT Function
- Exact Function in excel
- CLEAN Function in excel
Concatenate Excel Function
CONCATENATE function in Excel CONCATENATEs (joins) several text strings into a single text string.
RIGHT Function in Excel
RIGHT String Function in excel is used to calculate return the last character or characters in a supplied text string, based on the number of characters specified.
LEN in Excel
LEN String Function in Excel can be used to count the number of character in a text string and able to count letters, numbers, special characters, non-printable characters, and all spaces from an excel cell.
LEFT Function in Excel
LEFT function is a function which allows you to extract a substring from a string and starts from the leftmost character.
Search Function in Excel
The Excel SEARCH function is text function which is used to find the location of a substring in a string/text.
TEXT Function in Excel
Text function in excel is basically used to convert the numeric values into text in excel format that is specified.
PROPER in Excel
PROPER function is categorized as String function in excel.
MID in Excel
MID function is categories as text function in excel used to extract the substring from the middle of a string.
Trim in Excel
Trim function is categories as string function in excel is used to remove leading and trailing space from a string.
CLEAN Excel Function
CLEAN function in Excel is used to strip non-printable characters from an input string.
EXACT Excel Function
EXACT function in Excel is used to compare two text strings or values are exactly the same or not if so, returns TRUE else returns FALSE.
REPT Function in Excel
REPT Function in Excel is used to repeat the text a specified number of times.