Tag Archive: Text functions

Articles sur le thème : Text functions

Functions LEFT – RIGHT – MID

Text functions are convenient to extract a part of a cell. In the following examples, you will see in many examples how to extract a part of a cell LEFT function We want to extract the dialing code of cells. The dialing code is the first 3 digits of the phone number. To extract these figures, …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/left-right-mid/

Remove spaces in Excel with TRIM

When you import data, it is strongly recommended to use two following functions to “clean” the blank characters in your cells. The TRIM function This function is very useful for cleaning all the spaces before and after a string. The function is very simply to use. There is only one argument, your text to clean. …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/remove-spaces-in-excel-with-trim/

Title with date in Excel

Function TEXT converts any number into text and keep the specific number format. Presentation of the function TEXT TEXT function converts any number data into a text format according the parameters you give to the function. TEXT function has two parameters the number the format to apply Problem to solve Let’s take an example with …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/title-with-date-excel/

Function SEARCH

The function SEARCH allows you to find the position of a symbol into a string Presentation of function SEARCH The SEARCH function requires two parameters (and a third one optional) The first one is characters (or the sub-string) searched The second is the cell containing original string [Optional] The start position of your search. =SEARCH(Character …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-search/

Function LEN

Presentation of the LEN function The LEN function returns the number of characters in a cell. It’s simple 😉 =LEN(string) And that’s all? 🤔🤨😲 Yes that’s all! But this function is very usefull for the tests or for the conditional formatting Remarks If you have a string with coma, point, dash, space, … the LEN function counts every …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/function-len/