Tutorials

Web Development

Bootstrap CSS HTML JavaScript jQuery Node.js PHP React TypeScript

Programming

C C#C++Go Java Python Rust

Data and Databases

AI Foundations Cybersecurity Fundamentals Data Structures and Algorithms Data Visualisation Databases Excel Machine Learning NumPy Pandas SQL Statistics

Tools

Projects

Project: A Tiny Shell in C Project: Bank Account System Project: Library Management System Project: Portfolio Page Project: Quiz App in React Project: Sales Data Analysis Project: Server Log Analyser Project: To-Do REST API Project: URL Shortener Project: Word Counter in Four Languages

All tutorials ❯

Paths References

Practice

Try it editor Quizzes How To recipes Tools Glossary

Home › References › Excel Function Reference

❮ TEXTJOIN FIND ❯

SUBSTITUTE

Replaces text inside a text.

Group: Text

Syntax

SUBSTITUTE(text, old_text, new_text)

Example

Exampleexcel

Open in editor »

← All of Excel Function Reference