Text functions

Discover the power of the text function. Our tutorials cover various use cases and provide examples to help you implement it effectively.

The TRANSLATE function of Excel

Discover the new Excel 365 TRANSLATE function that simplifies text translation into another language in this article.

Unlock Excel's potential for text manipulation. Learn to split text based on patterns using the versatile MID function.

Discover the power of the LEN function in Excel. Easily count characters in cells for logical tests, conditional formatting, and more.

With Excel, you can extract a sub-string without writing formulas with the FlashFill. FlashFill is the first AI tool in Excel

Optimize your coding with the TRIM function. Say goodbye to pesky leading and trailing spaces in your strings.

How to extract the worksheet name with a formula in Excel? There is 2 solutions explain in this article.

What does mean the sign & in Excel? This sign is very important in many situation to link 2 cells together.

Discover the new TEXTSPLIT function in Excel 365 that allows you to split cell content using specified delimiters easily.

Easily extract specific data from Excel using the new TEXTBEFORE and TEXTAFTER functions. These functions simplify the way to extract text.

Want to count words in Excel? Check out these two techniques using the TEXTSPLIT function and the COUNTA function.

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

With Excel, you can easily convert any number to a Roman number and also the other way round to convert a Roman number to Arabic number

Keep the leading 0 in Excel is important when you want to keep all the digits of your strings and to avoid mistakes

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.

Want to extract numbers from cells with mixed characters? Discover the step-by-step process using the SEQUENCE and FILTER functions.

Discover How to Extract Only the Unique Values of a list of data in Excel with the UNIQUE function.

In Excel, you can split your text by a delimiter without using a formula with an internal tool. Explanation in this article.

Find out how to capitalize the first letter in Excel using three powerful tools: PROPER function, Power Query, and macros.