RIGHT Function Archives

VLOOKUP to Search Text in Excel (4 Easy Ways)

Nov 8, 2021 Excel Formulas

Today I will be showing how to use VLOOKUP to search text in Excel. One of the most amazing and widely used functions of Excel is VLOOKUP. The ...

How to Sort by Last Name in Excel (4 Methods)

Nov 1, 2021 Excel Basics

If you work with datasets in Excel, you will often need to sort these datasets by name. Sometimes. You may need to sort the dataset based on your ...

How to Sort by Last Name in Excel (4 Methods)

How to Use RIGHT Function in Excel (With 6 Easy Examples)

Nov 11, 2021 Excel Formulas

RIGHT is another popular function in MS Excel that is used to get the last character or characters in a text string, based on the specific number of ...

How to Use FIND Function in Excel (7 Suitable Examples)

Nov 14, 2021 Excel Functions

In Microsoft Excel, the FIND function is generally used to extract the position of a defined text in a cell containing a text string. In this ...

How to Use LEN Function in Excel (Formula and VBA Code)

Nov 14, 2021 Excel Formulas

Excel provides a function called LEN for counting letters, numbers, characters, and all spaces. LEN is a short form of LENGTH. LEN function is used ...

How to Use DATEVALUE Function in Excel (6 Suitable Examples)

Nov 18, 2021 Excel Functions

DATEVALUE function in Microsoft Excel is generally used to convert a text date into the date-time number codes. In this article, you’ll get to learn ...

Excel Compare Two Cells Text (9 Examples)

Oct 17, 2021 Excel Formulas

When we do compare two cells manually, it is not an issue. But it's next too difficult to locate the variations between hundreds and thousands of ...

How to Split One Cell into Two in Excel (5 Useful Methods)

Nov 15, 2021 Advanced Excel

When you import data from a database or any other sources, you have to split cell one into two or more in such situations. In this tutorial, I’m ...

How to Separate Numbers in Excel Using Formula (5 Ways)

Oct 19, 2021 Excel Formulas

Sometimes we may need to separate or get only numbers from any text and number combined input. Without doing this manually Excel provides various ...

Extract Only Numbers from Excel Cell (6 Useful Methods)

Nov 8, 2021 Excel Formulas 2

Although Microsoft Excel has not provided a straight formula or syntax to extract only numbers from the cells, but we can incorporate a wide range of ...

How to Separate Text and Numbers in Excel (4 Easy Ways)

Oct 19, 2021 Excel Formulas

We often have to separate text and numbers from some data in Excel. Today I will be showing 4 easy ways how you can accomplish that conveniently. ...

Excel Split Cell by Delimiter Formula

Oct 19, 2021 Advanced Excel

This tutorial will show you how to split cells with the help of a delimiter in Excel. A delimiter is a character that separates chunks of data within ...

Excel Convert Number to Text with Leading Zeros: 10 Effective Ways

Oct 14, 2021 Advanced Excel

Leading zeros aid predominantly to specify the length of a number. In the case of maintaining records such as any special identity number, zip code, ...

How to Add Leading Zeros in Excel (4 Quick Methods)

Oct 28, 2021 Excel Formulas

While working in Excel, we often have to add leading zeros before one or more numbers. This is in fact quite easy to implement. Today I will be ...

Add or Keep Leading Zeros in Excel (10 Suitable Ways)

Oct 28, 2021 Excel Basics

In Microsoft Excel, it’s not possible to keep leading zeros by simply typing a number with 0’s at first as Excel, by default, will remove those zeros ...