Reversing the Word Order within a String in Microsoft Excel

In this article we will write the formula to reverse the word order within a string in Microsoft Excel. We will use LEFT, RIGHT, LEN and FIND functio...

Extracting the First N Number of Words from a String in Excel

This article is about how to extract the first N number of words from a string in Microsoft Excel by using formulas. To solve this problem we will use...

Determining Long Distance Phone Calls, Based on the Number Dialed

To determine long distance phone calls based on the number dialed, we need to use the IF, AND, LEFT, and MID functionsin Microsoft Excel 2010 and 2013...

Splitting a full address into three or more separate cells in Microsoft Excel

Original Question:- How to split a cell into 3 different cells? I am importing text file in Excel, but all data is importing in a column I want ...

How To Add Zero In Front Of Number In Excel

In this article, we will learn Different ways to add zeroes (0s) in front in Excel. Scenario: Adding Zero in front of the number in Excel. Def...

Copying Formulas from a Range of Cells Without Changing the Absolute or Relative References in Excel

In this article we'll learn how to copy formulas in Excel without changing the cell reference or in simple words we can say that how to copy exact for...

Removing duplicate values by comparing values in two consecutive columns

  In this article, we will create a macro to check duplication and remove duplicate values from two consecutive columns. Raw data consists of t...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.