Excel has a lot to offer when it comes to manipulating text strings.
Joining strings
To join multiple lines into one, use the operator & (concatenations).
=A1&" "&B1
Note: To insert a space, use » » which is a space character enclosed in quotation marks.
LEVSIMV
To extract characters from a string on the left, use the function LEVSIMV (LEFT).
=ЛЕВСИМВ(A1;4)
=LEFT(A1,4)
RIGHT
To extract characters from a string on the right, use the function RIGHT (RIGHT).
=ПРАВСИМВ(A1;2)
=RIGHT(A1,2)
PSTR
To extract characters from the middle of a string, use the function PSTR (MID).
=ПСТР(A1;5;3)
=MID(A1,5,3)
Note: The function extracts 3 characters starting from position 5.
DLSTR
To get the length of a string, use the function DLSTR (ONLY).
=ДЛСТР(A1)
=LEN(A1)
Note: Including space (position 8)!
TO FIND
To find the position of a substring in a string, use the function TO FIND (FIND).
=НАЙТИ("am";A1)
=FIND("am",A1)
Note: The string “am” was found at position 3.
SUBSTITUTE
To replace existing text in a string with new text, use the function SUBSTITUTE (SUBSTITUTE).
=ПОДСТАВИТЬ(A1;"Tim";"John")
=SUBSTITUTE(A1,"Tim","John")
