String modification

LOWER(), the English version LOWER () makes all letters in lower case text (lowercase).

UPPER()the English version UPPER(), makes all letters in the text UPPERCASE (CAPITAL).br>

Double quotes " are often found in the names of companies, names of products, articles. As double quote is a special character, you can expect to get rid of them is not so simple.

If the name and otchestvo written together, for example, "Petrogiannis", it is possible to create a formula of separation to get the "Petrov, Ivan".

Combine values from multiple cells into one cell.

In one cell you can display 2 values. In fact, it certainly will be one text value, but looks like two.

Spaced Surname, Name and Patronymic (name) of a contained in one cell, on different columns.

Find the position of the third, fourth, etc. occurrences of words in a text string.

Convert the full name into the Surname + Initials.

If the string in the cell contains a name, for example "Petrov Vasily Ivanovich", it is possible to create a formula to output name or the name with initials.

If the string in the cell contains a name, for example "Petrov Vasily Ivanovich", it is possible to create a formula to output the first word (the surname).

If the string in the cell contains several words, for example, "Vasily Ivanovich Petrov", it is possible to create a formula to output the last word.

If the text string in the cell contains several words, for example, "Vasily Ivanovich Petrov", it is possible to create a formula to display, for example, the first (second, third, etc.) words.

Manual translation of formulas from English to Russian is always tedious. For example, if you want to translate RIGHT(A1,LEN(A1)) RIGHT(A1,LEN(A1)). Try to automate the process.

Let the text string contains letters and text. For Example, "Филатова623". Remove numbers from text string and turn it into just text "Filatov".

Let the text string contains letters and text. For example, "623Филатова". Remove numbers from text string and turn it into just text "Filatov".

let us Consider the insertion into a cell of text from WORD that contains several paragraphs and tab characters.

it is Often necessary to distance textowo string from one cell in several. This can be either the full name "Ivan Ivanovich Ivanov" or the address "Moscow, Northern Blvd., 133" or passport details. Use the text import wizard.

Retrieve the number from the middle of a text string, for example, the string "Пет555ров" get "555".

Retrieve the number from the beginning of the text line, for example, the string "123Филатова" get "123".

Retrieve the number from the end of a text string, for example, the string "Филатова123" get "123".