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

The TRIM function This function is very useful for cleaning all the spaces before and after a string. When you import data, it is strongly recommended to use two following functions to “clean” the blank characters in your cells. 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

The TEXT function changes the format of the numbers in a string

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

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

Function SEARCH

Presentation of function SEARCH The function SEARCH allows you to find the position of a symbol into a string 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 – Test a String Length

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 useful for logical tests or for conditional formatting Remarks If you have a string containing a comma, point, dash, space, etc. the LEN function counts every …

Continue reading

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

Extract text without a formula

FlashFill

In Excel 2013 and later, you can extract text without a formula using Flash Fill. What is Flash Fill? FlashFill is a tool integrated into Excel, that runs in the background continuously. You don’t have to click anywhere on the ribbon to activate it. You just have to fill in what you want to extract. Extract …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/extract-text-without-formula/