1. Computing
Ted French

Truncate Text Strings in Excel

By July 26, 2013

Follow me on:

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

Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.