SUBSTITUTE Function in Excel | Replace Specific Text Easily

In this Excel tutorial, learn how to use the SUBSTITUTE function to replace specific text or characters inside a cell. Works great for: Replacing incorrect spellings Cleaning data (like "kg", "K.G.", "Kilograms") Fixing phone numbers or symbols Replacing only the first, second, or all instances of a word Formula syntax: =SUBSTITUTE(text, old_text, new_text, [instance_num]) #exceltips #excelfunctions #textfunctions #exceltutorial #datacleaning #learnexcel #excelautomation