Cut pieces of text in Excel
LEFT (text; [num_chars])
RIGHT function allows you to cut out the text of a given length from the end of the text (from right). Its syntax is as follows:
RIGHT (text; [num_chars])
For both functions num_chars argument is optional. When you ignore it, it will be downloaded by default only one character of text – the first in the event of the LEFT function, the last in the RIGHT function. If num_chars will be greater than the length of the text, the functions return the entire text.
To display a certain number of characters from text starting at a specific location allows MID function. Here’s the syntax:
MID (text; start_num; [num_chars])
start_num is the place from where we want to start cutting operations.
For example, to start from the beginning of the text, type 1 (position of the first character). The argument here num_chars works the same way as in the previous two functions – if the argument start_num total more than the entire text, the function returns characters from the specified position to the end of the text. The following illustration shows how to use the function: