During work in Excel we often need process the text in the cells, but sometimes is difficult to understand which function we should use.
Let’s review some functions which will help us to do that.
This function allows us to separate the required number of characters from left side:
LEFT(text; number_of_characters)
In this example we have separated the balance part from the account number.
The same action we can do with the right part of the text.
RIGHT(text; number_of_characters)
Let’s try to cut some characters from the middle of the text:
MID(text; start_position; number_of_characters)
How we can see in this function appears additional argument, which in charge of start number of cutting. Namely digit “5” indicates start point of text cutting, and digit “4” – number of characters we want to get. Thereby we obtain 4 characters from the middle of the text starting from 5th character inclusively.