Learn Microsoft Excel Online FreeThis post will guide you how to check if one value in a column exists in another column in Excel. How do I check if value in column A exists in Column B with a formula in Excel. How to determine if values exists in another column in Excel. Check If Value in a Column… read more »
This post will guide you how to split date and time into separate cells in Excel. How do I Separate dates and times into two separate cells in Excel. How to split a data into multiple cells in Excel. How to separate Date and time data into 2 different cells with a formula in Excel…. read more »
This post will guide you how to find the earliest date in a range of dates in Excel. How do I get the earliest and latest date in a range with a formula in Excel. How to find the highest and lowest date in a range of dates in Excel. Assuming that you have a… read more »
This post will guide you how to remove leading and trailing spaces in cells in Excel. How do I remove leading or trailing spaces in a range of cells with a formula in Excel. How to remove trailing spaces from cells with VBA Macro in Excel. Remove Trailing Spaces from Cells with Formula If you… read more »
This post will guide you how to sum only negative numbers in Excel. How to sum only positive numbers in Excel. How do I sum both positive and negative numbers in Excel. How to make the sum in a range show as a negative number in Excel. Sum Only Positive Numbers or Negative Numbers If… read more »
This post will guide you how to count cells that contain positive or negative numbers in Excel. How do I count positive and negative values with a formula in Excel. How to count all negative number or positive number in a given range of cells in Excel. Count Positive or Negative Numbers If you want… read more »
This post will guide you how to extract month and year from a date in excel. How do I get month and year from date cells with a formula in Excel. How to convert date to month and year in Excel. Extract Month and Year from Date If you want to extract month and year… read more »
This post will guide you how to repeat cell value N times in Excel. How do I copy cell value N times in Excel. Repeat Cell Value N times Assuming that you have a list of data that contain two column and one column is cell value that you want to repeat, and another column… read more »
This post will guide you how to convert scientific notation to text or a number in Excel. How do I convert excel scientific to text with a formula in Excel. Convert Scientific Notation to Text or a Number in Excel Assuming that you have a list of data in range B1:B4 that contain scientific notation… read more »
This post will guide youw how to reverse the concatenate function in Excel. how do I split the text string into the muliptle cells with a formula in Excel. How to split text data of a cell to multiple cells in Excel. Reverse Concatenate Formula To reverse concatenate formula in Excel, you can use a… read more »
