|
|
Text function - the basis - Function TRIM
Page visited 11706 times
|
1. It is very important to know the text functions to enhance all your data and customize your result. First of all, you must know the sign & which provide to mix in a cell function and text.
|
|
|
|
|
|
|
|
|
2. In this example, you have 3 different cases with 3 different functions and text. .
Warning: In this case, the format of the cell is always a text format. Therefore you can’t reused the contain of this cell in another cell.
|
|
|
|
|
|
|
|
|
3. Another very important function is the TRIM function. This function cleans all space before and after any string in a cell. This is very usual when you import data from the Web.
|
|
|
|
|
|
|
|
|
4. In this example, you can’t sort properly your data because there is a space before some strings. So you must clean yours cells with the following function
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
5. Once you have copied your formula, you must convert the result of the column B in text. So each time you have to used the TRIM function, you must make a Special paste / Value. It’s the only way to clear easily your data.
|
|
|
|
|
|
|
|
|
