03
Nov
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...
03
Nov
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...
03
Nov
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 ...
03
Nov
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...
03
Nov
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...
03
Nov
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, ...
03
Nov
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...