RIGHT Function

Excel Formula to Split: 8 Examples

Excel formula helps us to split a cell or a text string or a column. This makes the dataset more readable and easily accessible to the correct ...

Excel Formula to Split One Column into Multiple Columns (4 Examples)

Excel formulas help us to find value from a long column by splitting one column into multiple columns. These make the dataset more readable and ...

How to Split String by Length in Excel (8 Ways)

If you are looking for some of the easiest ways to split string by length in Excel, then you are in the right place. So, let’s get started with this ...

How to Convert General Format to Date in Excel (7 Methods)

Working with Microsoft Excel's Date format is very common. We use them for various calculations. The Date is one of the essential formats in Excel. ...

How to Split One Column into Multiple Columns in Excel (7 Easy Ways)

Sometimes it becomes difficult to find value from a long Excel column. So we need to split one column into multiple columns in Excel. It makes the ...

How to Separate Two Words in Excel (6 Easy Ways)

Separating two words in Excel is quite handy in order to extract data from a dataset. In this article, we use LEFT, RIGHT, LEN, SEARCH, FIND ...

How to Convert Text to Date in Excel (10 ways)

If you are looking for some of the easiest ways to convert text to date in Excel, then you will find this article useful. So, let’s dive into the ...

Convert Number (YYYYMMDD) to Date Format in Excel (4 Methods)

You might have the date in your dataset in a format like YYYYMMDD (e.g., today’s date is 20211128) or, as the count of total days since January 1, ...

How to Convert Number to Date in Excel (6 Easy Ways)

Sometimes in Excel, we input the date but it returns it as a bunch of numbers as it stores the date value as a number. This makes the dataset very ...

How to Add Space between Numbers in Excel (3 Ways)

While working with numbers in Excel, you may need to insert space(s) between numbers to have a clear look. Sometimes, the numbers of a cell are too ...

How to Remove Specific Characters in Excel ( 5 Ways)

Sometimes our Excel datasheet contains unnecessary characters which we may want to remove. In this article, I’ll show you five easy and simple ways ...

How to Remove Specific Text from Cell in Excel (Easiest 11 Ways)

If you are looking for some of the easiest ways to remove specific text from a cell in Excel, then you will find this article worth it. While working ...

How to Remove Special Characters in Excel (4 Methods)

Many times the database contains some special characters which we do not need in the database and we want to remove them. We can easily perform this ...

How to Remove Text From Excel Cell (9 Easy Ways)

There are several methods to remove text from an Excel cell. In this article, I’ll show 9 methods including VBA to remove text from the Excel cells. ...

Remove First Character from String in Excel (6 Quick Ways)

Sometimes we need to remove the first character from the string to make the dataset shorter as well as pleasing. Today in this article, we are going ...

ExcelDemy
Logo