1. Technology

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.
You can opt-out at any time. Please refer to our privacy policy for contact information.

©2014 About.com. All rights reserved.