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/

Function TRIM - SUBSTITUTE

  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 up all the spaces before and after a string. This is very common when you copy/paste data from the Web. The function works …

Continue reading »

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

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/