There’s no SUBSTRING function in Excel.

This example shows the difference between the SUBSTITUTE function and the REPLACE function.

When joining text and a number, use the TEXT function in Excel to format that number.

To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’.

This example teaches you how to separate strings in Excel.

Use the SEARCH function in Excel to find the position of a substring in a string.

Use the FIND function in Excel to find the position of a substring in a string.

Use the CONCATENATE function in Excel to concatenate (join) strings. Instead of using CONCATENATE, simply use the & operator.

This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive.