Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Excel Courses

substitute function

  • Home
  •   »  
  • substitute function
Excel
Clean up Large Text Strings in Excel

How to Clean Large Text Strings (LEN, CHAR, CONCATENATE, and more)

Following up on our post about some of the most commonly used text functions, today we’re going to focus on cleaning up

Videos
substitute function excel

How to use the Substitute Function (Video)

If cleaning up messy data is part of your work flow, the substitute function is sure to come in helpful. Learn how to use it here:

Excel
sutbstitute formula excel

Using SUBSTITUTE and CHAR to remove a block of unwanted text

The SUBSTITUTE function is incredible for cleaning up text. You can replace a string of text with whatever you’d like,

Functions Text Functions
SUBSTITUTE – Excel Function

SUBSTITUTE – Excel Function

What it Does: The SUBSTITUTE() function in Excel substitutes one or more instances of a string (or number) for something

  • Articles
  • Videos
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Text Functions
    • Math Functions
    • Logical Functions
    • Lookup and Reference Functions
Copyright ©2022 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com