excel tutorialText Functions in Excel
Excel has many functions to offer when it comes to manipulating text strings. This chapter gives an overview of the most important text functions. Below you can find the results of some text functions and the functions used to obtain these results. You can download the accompanied Excel file if you want.
Explanation:
| Cell B6 | to join text strings, use the CONCATENATE function. |
| Cell B7 | to insert a space, use " " as extra argument for the CONCATENATE function. |
| Cell B8 | to extracts the leftmost characters from a text string, use the LEFT function. |
| Cell B9 | to extract a substring, starting in the middle of a text string, use the MID function. |
| Cell B10 | to extracts the rightmost characters from a text string, use the RIGHT function. |
| Cell B11 | to get the length of a text string (including possible spaces), use the LEN function. |
| Cell B12 | to find the position of a substring in a text string, use the FIND function. |
| Cell B13 | to extract the first word, use the LEFT function and the position of the space. |
| Cell B14 | to extract the second word, use the RIGHT function, LEN function, and the position of the space. |
| Cell B15 | the TRIM function removes extra spaces, beginning spaces and ending spaces from a text string. |
| Cell B16 | the LOWER function converts all letters in a text string to lowercase. |
| Cell B17 | text is in proper case when the first letter of each word is in uppercase and the rest is in lowercase. |
| Cell B18 | the UPPER function converts all letters in a text string to uppercase. |
| Cell B19 | the SUBSTITUTE function replaces existing text with new text in a text string. |
| Cell B23 | to count the number of words in a cell, subtract the length of the text string without spaces from the length of the text string with spaces and add 1. |
Did you like this free Excel tutorial? Show your appreciation, vote for us.