Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Merch
  • Excel Courses

code

  • Home
  •   »  
  • code
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
Char Function Microsoft Excel

CHAR – Excel Function

What it does: The CHAR() returns the character specified by a number. Plain English: When you see CHAR(), think

  • 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