How to Convert Text to Numbers in Excel (5 Ways)
5 Ways to Convert Numbers Stored as Text to Numbers in Excel by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) There are several ways to convert text to numbers in Microsoft Excel. When data is...
Use Excel Conditional Formatting to Highlight Dates Before Today (3 Ways)
Highlight Dates Before Today in Excel Using Conditional Formatting by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can use conditional formatting in Excel to highlight cells containing dates...
How to Replace Spaces in Excel with Underscores (_), Dashes (-) or Other Values
3 Ways to Replace Spaces Between Characters in Excel Text Strings by Avantix Learning Team | Updated October 20, 2021 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) In Excel, you can replace spaces in text strings with underscores, dashes or...
How to Replace Blank Cells in Excel with Zeros (0), Dashes (-) or Other Values
Quickly Fill Blanks with Zeros or Other Values in Excel Worksheets (0, -, N/A, Null or Other Text) by Avantix Learning Team | Updated June 26, 2026 Applies to: Microsoft® Excel® 2016, 2019, 2021, 2024 and 365 (Windows) You can quickly replace blank cells in Excel with...Follow Us
