Excel Formula Examples

Split Dates into Separate Cells in Excel

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 »

Remove Trailing Spaces from Cells in Excel

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 »

Sum Only Positive Numbers or Negative Numbers in Excel

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 »

Count Positive or Negative Numbers in Excel

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 »

Extract Month and Year from Date in Excel

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 »

Repeat Cell Value N times in Excel

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 »

Convert Scientific Notation to Text or a Number in Excel

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 »

Reverse Concatenate Formula in Excel

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 »

Sidebar