Filed In:
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.