Manipulate Text by using Excel Commands and Functions 

text logo
msofficeshare logo

The attached file (Manipulate Text by using Excel Commands and Functions.xlsx) illustrates different methods to manipulate text.   Each method contains examples and formula.  Those commands and functions will come in handy when you need it.  The attached file includes below command and functions:

Command:  Text to Column.

 

Functions:  LEFT, RIGHT, LEN, FIND, SUBSTITUTE, CONCATENATE, TRIM, CLEAN, COUNTA, COUNTBLANK, COUNTIF, EXACT, FIXED, ISTEXT, ISNONTEXT, LOWER, UPPER, PROPER, REPLACE, and REPLACEB.