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

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

Learn how 5 powerful Excel functions can enhance data analysis, financial modeling, and reporting with practical solutions.

Substitute and Replace functions are text functions. We explain how to use the Substitute and Replace functions in Microsoft Excel.

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Learn how to use the new Microsoft Excel REGEX functions to easily extract, clean and format data for easy data visualization and analysis ...

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.