Regular expressions (regex) are powerful tools for text processing that allow you to match, extract, and replace text based on specific patterns. Excel doesn’t natively support regex, but you can use third-party add-ins to bring this functionality to your spreadsheets. One … [Read more...] about How to Use Regex in Excel: A Beginner’s Guide
excel how to
10 Creative Ways to Use Excel Mobile in your Business
Microsoft Excel Mobile is a powerful tool that can be used in a variety of ways to help businesses run more efficiently. The possibilities are endless, but here are 10 creative ways you can use Excel Mobile to boost your business: … [Read more...] about 10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
The Copy and Paste functions are something we use practically every time we work with some Office document. But have you noticed that when you use the paste functionality, the Paste Options pop up menu lingers on and refuses to go away? This is quite annoying and often ends up … [Read more...] about How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
In a previous post, I showed you how to use the NETWORKDAYS() function in Excel to calculate the number of work days between two dates in Excel. In today’s post we’ll take a look at how you can use further Excel functions to calculate number of days between two dates in Excel. … [Read more...] about How to Calculate Number of Days Between Two Dates in Excel
How to Combine Text with a Date or Time in Excel
There is no straightforward way to enter a string of text in Excel along with a date or time. Excel simply does not allow you to combine text and dates or text and time together in the same cell. However, there is a simple workaround that makes it possible for you to do this. In … [Read more...] about How to Combine Text with a Date or Time in Excel
How to Hide Data in a Worksheet in Excel
There may be times when you want to share or view some data in an Excel worksheet, but not all of its contents. In such cases, you can hide the data from view. In this Excel tutorial, I’ll show you two ways in which to hide data in a worksheet in Excel 2016. … [Read more...] about How to Hide Data in a Worksheet in Excel
How to Calculate the Age of a Person in Excel
If you’re working with a lot of employee data and need to create an maintain a database with the employee’s ages, automatically updated every year, you can make use the the functions in Excel to do it. For this purpose all you need is the year of their birth or their date of … [Read more...] about How to Calculate the Age of a Person in Excel
How to Get the Name of a Day from a Date in Excel
Got a series of dates in Excel and want to know how to get the name of a days they fall on? Here’s a quick Excel guide to help you with that using a simple formula with some variations. Here's how to get the name of a day from a date. … [Read more...] about How to Get the Name of a Day from a Date in Excel