Text
How to use Substitute vs Replace in Excel
This example shows the difference between the SUBSTITUTE function and the REPLACE function.
How to use Text Function in Excel
When joining text and a number, use the TEXT function in Excel to format that number.
How to use Text to Columns in Excel
To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’.
How to use Search function In Excel
Use the SEARCH function in Excel to find the position of a substring in a string.
How to Use Find function in Excel
Use the FIND function in Excel to find the position of a substring in a string.
How to use Concatenate function In Excel
Use the CONCATENATE function in Excel to concatenate (join) strings. Instead of using CONCATENATE, simply use the & operator.
How to use EXACT function Compare Text In Excel
This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive.