How to use no SUBSTRING function in Excel

Nov 06, 2020

There's no SUBSTRING function in Excel.

#Tutorial#How To#Functions#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 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.