MEDIAN IF Formula

median if formula in excel

Learn how to use the MEDIAN IF array formula to identify the middle number of values that meet specific criteria.

VLOOKUP multiple matches

vlookup multiple matches

This Excel guide will show you how to return and display multiple matches using the VLOOKUP function.

Get first name from name

get first name from full name in Excel

Learn how the get the first name from a name using regular (LEFT, FIND) and user-defined (TextLeft, ExtractWord) functions.

Join first and last name

join first and last name

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 last name from name

how to find and get last name from full name

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

Remove characters from right

remove characters from right in Excel

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.

Split dimensions into two parts

split dimensions into two parts

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

Get first word from some text

get first word from some text

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

Trim text to n words

trim text to n words in Excel

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.