Split your text on a delimiter – TEXTSPLIT Function

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

Functions LEFT – RIGHT – MID

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

Position of a character in a string with SEARCH function

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.

Capitalize the first letter in Excel (Camel Case)

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

Title with Text and Date in the same cell

Learn how to use the TEXT function in Excel to format numbers and keep the desired number format inside a string.

Create test on String Length with LEN

The LEN function returns the number of characters is a cell. It's very useful if you have to check the length of names, codes, references