by Ilker | Nov 22, 2022 | Excel Formulas
The TEXTAFTER function is a Text function that returns part after a given character or string. In this guide, we’re going to show you how to use the TEXTAFTER function and go over some tips and error-handling methods. Supported versions Excel 365 (Office Insider Beta...
by Ilker | Nov 2, 2022 | Excel Tips & Tricks
You might have already seen that Excel's date-related functions return errors or incorrect values with external data. The most common reason is the difference between date formats, such as reverse day and month figures. Usual scenario between US and European...
by Ilker | Jun 23, 2022 | Excel Tips & Tricks
Excel keeps growing its visualization tools with each version. And the charts are the flagship of those. Although they present lots of customization options, they may become overwhelming when you just need to create a simple bar or column chart. In this guide, we’re...
by Ilker | Mar 29, 2022 | Excel Tips & Tricks
Neither words nor grammar is where Excel shines. On the other hand, texts may be handful to inform users what a numeric value means, such as units. Making this type of information changed between singular and plural forms dynamically may increase the end-user...
by Ilker | Sep 30, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download Macro-Free Workbook Download Workbook Note that, there isn't a single formula or approach that can handle all scenarios. Extracting dates from strings...
by Ilker | Sep 10, 2021 | Excel Tips & Tricks
Neither Excel is a word processing software, nor most of Excel users do care about spell checking in their workbooks. However, Excel does have a spell check feature even though it is not as powerful as Word or PowerPoint offers. In this guide, we’re going to show you...
by Ilker | Jul 2, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to convert date to text in Excel. Download Workbook Date and time in Excel Excel stores date and time values as numbers. They will be displayed in regular date or time format, because Excel automatically applies number...
by Ilker | Jun 15, 2021 | Excel Tips & Tricks
You can use text functions to manipulate text strings in Excel. However, you can’t use them with regular expressions. As of writing this article VBA is your only option. In this guide, we’re going to show you how to use regular expressions in Excel. Download...
by Ilker | Jun 7, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to strikethrough in Excel. Download Workbook Strikethrough is a handy formatting option to eliminate data that is not relevant anymore. Let’s see how you can apply this formatting in Excel. Keyboard shortcut Simply press the...