### 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.