Excel IF

How to Enter\Fill Special Texts into Blank Cells in Excel

Sometimes we open an excel file and find there are some blank cells in the worksheet. We want to mark them with special texts so that readers can find them easily and ignore them. From this article, we will provide you two ways to enter special texts into blank cell to mark them different with… read more »

How To Align Duplicate Values within Two Columns in Excel

This post will guide you how to align duplicate values within two columns based on the first column in your worksheet in Excel. How do I use an formula to align two columns duplicate values in Excel. Aligning Duplicate Values in Two Columns Assuming that you have two columns including product names in your worksheet…. read more »

How To Split Columns to Seprated Negative and Positive Values in Excel

This post will guide you how to separate negative numbers and positive numbers from a column into two columns with a formula in Excel. How do I split numbers into two columns with negative and positive numbers in Excel. Splitting Columns to Separated Positive and Negative Numbers Assuming that you have a list of data… read more »

How to Extract Initials From a Name in Excel

This post will guide you how to get initials from a given name using a formula in Excel. How do I extract initials from names in Excel 2013/2016. Extract Initials from a Name Using a Formula Extract Initials from a Name Using User Defined Function Assuming that you have a list of data in range… read more »

How to Compare Two Columns for Differences in Excel

This post will guide you how to compare two columns and return differences in Excel. How do I compare two columns to find differences in Excel 2013/2016. Compare Two Columns for Differences Assuming that you have a list of data in range A1:B5, and you want to compare Column A and Column B and return… read more »

How to Remove Last or Trailing Commas in Excel

This post will guide you how to remove trailing commas from cell in Excel. How do I remove comma character at the end of a cell with a formula in Excel 2013/2016. Remove Trailing Commas if you want to remove trailing commas from you Excel cells, and you can create a formula to check for… read more »

How to Move Every Other Row to a New Column in Excel

This post will guide you how to move every other row to a new column in Excel. How do I move every odd row to another column with formula in Excel 2013/2016. How to move every even row to other column in Excel with VBA Macro in Excel. Move Every Other Row to New Column… read more »

How to Lookup Values from Right to Left in Excel

This post will guide you how to vlookup values from right to left in your worksheet in excel. How do I look up values to left column with a column in Excel 2013/2016. How to use Vlookup function to extract the corresponding value of the left column in your worksheet in Excel. Lookup Values to… read more »

Sidebar