# Text Functions

Excel's Text Functions help you manage the text data in your spreadsheets.

## Combine Text Strings in Excel with the Concatenate Function

Excel's CONCATENATE function is used to join two or more words or text strings together. This tutorial includes a step by step example of using Excel's CONCATENATE function.

## Excel MID function: Extract a Substring in Excel

The MID function can be used to extract a substring from a text string in Excel. This tutorial includes a step by step example of using the MID function to extract a subtring of data in Excel.

## Excel LEFT function: Truncate Text Strings in Excel

Excel's LEFT function can be used to truncate text strings or remove unwanted characters from imported data. This tutorial includes a step by step example of using Excel's LEFT function to truncate imported text data.

## Excel RIGHT function: Truncate Text Strings in Excel

Excel's RIGHT function function can be used to truncate text strings or remove unwanted characters from imported data. This tutorial includes a step by step example of using Excel's RIGHT function to truncate imported text data.

## Remove Extra Spaces Between Data in Excel

This tutorial contains a step by step example of how to remove extra spaces from between words in Excel using the TRIM function.

## Convert Text to Numbers in Excel

How to convert text to numbers in Excel using the VALUE function. This tutorial contains a step by step example of how to convert text to numbers in Excel using the VALUE function.