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

Formulas

How to Auto Format Formulas in Excel (3 Easy Ways)

Autoformat Formulas result after using conditional formatting

When working with formulas, there is always a possibility that someone (or even you) may delete a cell (or clear the contents of a cell/range) that has formulas in it. …

Read more

How to Extract URL from Hyperlinks in Excel (Using VBA Formula)

Using formula to extract URL from a cell in Excel

If you work with data copied from the web into Excel, you would often get a dataset that has hyperlinks in it. For example, below is an example dataset where …

Read more

Newer posts
← Previous Page1 … Page8 Page9

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

2023 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status