Truncate Text Strings in Excel

When data is imported or copied into a spreadsheet unwanted characters or words can sometimes be included with the new data.

Excel has several text functions that can be used to remove these unwanted characters.

The LEFT function is one such example. It allows you to specify how many characters in a cell you wish to keep and the rest are removed.

To find out the details of using this function read the short tutorial on how to Truncate Text Strings in Excel with the LEFT Function.

Related Tutorials

• Truncate Text Strings with the RIGHT Function
• Concatenate Text Strings in Excel
• Extract a Substring Using the MID Function