Formula

Learn how to remove file extensions from a filename using custom Excel functions. Also, use the LEFT and FIND functions to clean data.

How to join first and last names into a single full name? We will show you two methods to concatenate the names in Excel.

Get the last name from a full name quickly using TextRight and the Substring functions, or use an advanced Excel formula.

Learn how to remove characters from the right of the text using various Excel functions. Discover how to remove the last n characters from a text string.

Learn how to get the middle name from a full name using the MID, LEN, and TRIM functions for splitting the middle name.

Split dimensions into two parts! This tutorial will show you how to extract the left and right dimensions into separate values.

How to extract the first word from some text? We will show you various solutions using Excel’s FIND, LEFT, and ExtractWord functions.

Learn how to find and get the last word from a text string using the MID, FIND, CHAR, LEN, and SUBSTITUTE functions.

How to trim text to n words? We will show you various methods (regular functions and VBA) to get the first n words from a text string.

Learn how to abbreviate names or words using regular Excel functions or the ABBREVIATE user-defined function.

This tutorial will show you how to extract the nth word from a text string (a sentence or phrase) in Excel.

Learn how to split text with a delimiter (comma, space, or special characters) using the TRIM, MID, SUBSTITUTE, and LEN functions.