Create test on String Length with LEN
The LEN function returns the number of characters is a cell. It's very useful if you have to check the length of names, codes, references
Text functions
Functions LEFT – RIGHT – MID
In Excel it's easy to extract text string with the function LEFT, RIGHT, LEN and MID. Discover how to use them in this article
Remove spaces in Excel with the TRIM function
If you want to remove the extra spaces in a cell, there is a function for that ; it's the TRIM function. But you must convert your formula in values.
Title with date in Excel
The TEXT function is very useful when you have to create a string which mixed text and number or date. You can customize each part of your date
Find the position of a character in a string with SEARCH function
The SEARCH function is very useful when you don't know the position of a character in a string. Look at the example in this page to see how using it.
Extract text without a formula – Flash Fill
In Excel 2013 and later, you can extract text without a formula using Flash Fill.FlashFill is a tool integrated into Excel, that runs in the background continuously.
Capitalize the first letter in Excel
In Excel, it's easy to capitalize the first letter with a function, by VBA or with Power Query. All the techniques explain here.
Split your text on a delimiter – TEXTSPLIT Function
The new TEXTSPLIT function allows you to split the content of your cell on a delimiter. It's very easy to use.