Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Online Excel Training

substitute

  • Home
  •   »  
  • substitute
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

28 Apr
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,

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