How to convert text to speech in Excel

How to convert text to speech in Excel

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...
How to convert date to text in Excel

How to convert date to text in Excel

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...
How to split text in Excel in 5 ways

How to split text in Excel in 5 ways

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...
How to split text with Power Query in Excel

How to split text with Power Query in Excel

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...
How to split text with VBA in Excel

How to split text with VBA in Excel

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...
How to split text with formulas in Excel

How to split text with formulas in Excel

Excel has more than one way for splitting text, such as Text to Columns feature. However, the feature requires a manual user intervention. You can make the process dynamic with help of functions. In this guide, we’re going to show you how to split text with...
How to reverse a text string in Excel

How to reverse a text string in Excel

In this guide, we’re going to show you how to reverse a text string in Excel. Download Workbook Please note that as of we are writing this article, functions like TEXTJOIN and CONCAT are available for Excel 2019 and Microsoft 365 subscribers only. Syntax CONCAT...
How to consolidate text by a condition in Excel

How to consolidate text by a condition in Excel

In this article, we are going to show you how to consolidate text by a condition in Excel. Download Workbook Please note that we will be using the new dynamic array functions UNIQUE and FILTER in this post. These functions currently are only available to Office 365...