1. Computing
Ted French

Substitute New Text for Old in Excel

By July 1, 2013

Follow me on:

Excel SUBSTITUTE Function
Excel SUBSTITUTE Function
Ted French

Excel's SUBSTITUTE function lets you replace existing text data in one or more worksheet cells with new words, blank spaces, or other text.

Uses for the function include removing unwanted characters from imported data and producing different versions of one worksheet.

SUBSTITUTE is similar to Excel's REPLACE function except that SUBSTITUTE exchanges specific text at any location in the selected data while REPLACE exchanges any text that occurs at a specific location.

To find out the details, read this short tutorial on Excel's SUBSTITUTE 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.