Скачать или смотреть 10 Minute Excel Training - Text Manipulation

Key Takeaways:
TRIM: removes any unnecessary spaces in a string - LEN: shows the number of characters, including spaces, within a string
LEFT: pulls a specified number of characters starting from the left within a string
RIGHT: pulls a specified number of characters starting from the right within a string
MID: pulls a specific number of characters starting from a specific point (counting from the left) within a string
FIND: gives the location of a specific character(s) within a string
PROPER: formats a string to have the first letter of each word upper case
UPPER: formats a string to have all letters upper case
LOWER: formats a string to have all letters lower case
SUBSTITUTE: swaps a specific character(s) within a string with another specified character(s)
&: combines strings together