The Excel TEXTSPLIT function can split text strings by using row or column delimiters. Learn how to use the new TEXTSPLIT () function in Excel.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

Concatenate merges the data you have inserted into columns into its own cell or column in Excel. Let’s take a look at how to use concatenate in Excel.

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources.

An Excel spreadsheet containing a list of names and phone numbers in column A, and subsequent columns created where the information will be extracted through REGEXEXTRACT.

You can combine two columns in Excel using several formulas and tools available in the software. If the columns that you want to combine are empty, you can use Excel's merge function.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.