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 21, 2022 | Excel Formulas
The TEXTBEFORE function is a Text function that returns part before a given character or string. In this guide, we’re going to show you how to use the TEXTBEFORE function and go over some tips and error-handling methods. Supported versions Excel 365 (Office Insider...
by Ilker | Nov 7, 2022 | Excel Formulas
The TEXTSPLIT function is a Text function that returns an array of substrings split by a given delimiter. If you use the function itself, Excel spills the substrings into multiple cells as a regular dynamic array. In this guide, we’re going to show you how to use the...
by Ilker | Aug 23, 2022 | Blog
SpreadsheetWeb Hub supports Excel's LAMBDA function. The recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of the LAMBDA function. In this article, we will create a LAMBDA Function to...
by Ilker | Jul 5, 2021 | Excel Tips & Tricks
Excel has supported text-to-speech since 2003. In this guide, we’re going to show you how to convert text to speech in Excel using commands or VBA. Download Workbook Testing text to speech Follow the steps below to quickly test the text to speech functionality. Select...
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 | Apr 20, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to split text in Excel by a delimiter. Download Workbook We have a sample data which contains concatenated values separated by “|” characters. It is important that the data includes a specific delimiter character...
by Ilker | Mar 2, 2021 | Excel Tips & Tricks
Power Query is a data management tool in Excel. In this guide, we’re going to show you how to split text with Power Query in Excel. Download Workbook What is Power Query Power Query is a feature of Excel that makes access to data easier and manageable. If you...
by Ilker | Feb 25, 2021 | Excel Tips & Tricks
Text to Columns feature can help you split text strings in Excel. Using VBA, you can make this process even faster. In this guide, we’re going to show you how to split text with VBA in Excel. Download Workbook Data In this example, we have rows of data...
