How to use no SUBSTRING function in Excel
Nov 06, 2020
There's no SUBSTRING function in Excel.
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 Split a String In Excel
Nov 04, 2020
This example teaches you how to separate strings in Excel.
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
Oct 30, 2020
Use the FIND function in Excel to find the position of a substring in a string.
How to use Concatenate function In Excel
Oct 29, 2020
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
Oct 28, 2020
This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive.
©2020 Excel Examples.