How to split cells in Excel: Text to Columns, Flash Fill and formulas
How do you split a cell in Excel? By using the Text to Columns feature, Flash Fill, formulas or Split Text too...
Using REPLACE and SUBSTITUTE functions in Excel – formula examples
The tutorial explains the Excel REPLACE and SUBSTITUTE functions with examples of uses. See how to use the REP...
Excel IF statement with multiple Conditions
The tutorial shows how to create multiple IF statements in Excel with AND as well as OR logic. Also, you will ...
Excel TRIM function – Quick way to remove extra Spaces
The tutorial demonstrates a few quick and easy ways to trim Excel spaces. Learn how to remove leading, trailin...
How to use Find and Replace in Excel most efficiently
In this tutorial, you will learn how to use Find and Replace in Excel to search for specific data in a workshe...
Excel FIND and SEARCH functions with Formula Examples
In the last article, we covered the basics of the Excel Find and Replace dialog. In many situations, however, ...
How to use Excel RIGHT function – Formula Examples
In the last few articles, we've discussed different Text functions - those that are used to manipulate text st...