Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Excel Tutorials
  • Excel Video Lessons
  • 150 Keyboard Shortcuts
  • Contact

Text Functions

  • Home
  •   »  
  • Text Functions
Excel
sutbstitute formula excel

How to Remove Text from a Cell in Excel

One of the most frustrating problems in Excel is when you want to remove text from a cell. The SUBSTITUTE function is

Excel Training Videos
left, right, and mid functions

Learn the LEFT, RIGHT, and MID Functions in Excel

Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings

Excel Training 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:

  • Articles
  • Excel Training Videos
  • Books on Excel & Data
  • 150 Keyboard Shortcuts in Excel (Windows)
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Excel Text Functions
    • Excel Math Functions
    • Excel Logical Functions
    • Excel Lookup and Reference Functions
Copyright ©2023 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com