Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
  • Formulas
  • Charts
  • VBA / Macros

Formulas

How to Sum Positive Numbers in Excel – Easy Formula

SUMIF formula to add only positive numbers

For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …

Read more

How to Count Negative Numbers in Excel – Easy Formula

COUNTIF Function to count negative numbers in a range

Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …

Read more

How to Convert Date to Day of Week in Excel (3 Easy Ways)

Date to convert to the day name

When working with date-specific information, there might be instances where you need to find the day of the week corresponding to a date. For example, instead of the date, you …

Read more

How to Convert Serial Numbers to Date in Excel

TEXT function to change serial number to date

When you bring in data from other sources, it is not uncommon to get the dates in the form of serial numbers, like 42088. Moreover, Excel inherently stores dates in …

Read more

How to Remove a Specific Character from a String in Excel

Result after using the CLEAN function

A big part of processing data involves the cleaning of the data. Most data you bring in to Excel often comes from various sources. Many times they are converted from …

Read more

How to Convert Date to Month and Year in Excel (3 Easy Ways)

TEXT formula

Whenever you enter a date in a cell, Excel automatically recognizes the format and converts the cell to a date cell. So, Excel knows which part of the date you …

Read more

How to Add Text to the Beginning or End of all Cells in Excel

Final result of flash fill

There may be instances where you need to add the same text to all cells in a column. You might need to add a particular title before names in a …

Read more

How to Remove Text after a Specific Character in Excel (3 Easy Methods)

Formula result with only the username

When editing or cleaning data in your worksheet, one often needs to trim and remove certain parts of strings, either for formatting consistency or to make the dataset look neat …

Read more

How to Count How Many Times a Word Appears in Excel (Easy Formulas)

Copy and drag the formula for all cells

One common requirement when working with large datasets is counting how many times a particular word or value appears. You may need to know how many times the word appears …

Read more

How to Reverse a Text String in Excel (Using Formula & VBA)

Concatenate all the alphabets

Reversing a string may not have many real-world applications, especially when working with spreadsheets. That is why you will not find any built-in function for this in Excel. But there …

Read more

How to Convert Radians to Degrees in Excel (Easy Formula)

Degrees Formula

When working with mathematical data, there might be instances where you need to work on angles. Excel has a number of built-in trigonometric functions that let you easily calculate the …

Read more

How to Generate Random Numbers in Excel (Without Duplicates)

Unique random numbers without duplicates

Randomness is often just as necessary as order and symmetry, whether you are dealing with life or an Excel worksheet. Sometimes, you need it to ensure every value has an …

Read more

Post navigation
Older posts
Newer posts
← Previous Page1 … Page4 Page5 Page6 Next →

Most Popular Articles

How to Compare Two Columns in Excel (using VLOOKUP & IF)

Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples

How to Remove Dashes (-) in Excel?

How to Center the Worksheet Horizontally on the Page in Excel

How to Merge First and Last Name in Excel

How to Remove Commas in Excel (from Numbers or Text String)

Why does Excel Open on Startup (and How to Stop it)

How to Remove Apostrophe in Excel

How to Unsort in Excel (Revert Back to Original Data)
SpreadsheetPlanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

2022 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status