Excel FunctionsLesson 109Free preview

SUBSTITUTE

This lesson is part of Excel · All levels

Summary

SUBSTITUTE is an Excel text function that replaces the appearance of a particular text in a string with new text. The syntax is. Unlike REPLACE which works by position, SUBSTITUTE works by text matching.

Key points

Syntax: SUBSTITUTE(text, teks_lama, teks_baru, [nomor_urut])
Instance_num limits substitution to the n-section only
If instance_num is passed, all the appearances are replaced
Often used to delete spaces with SUBSTITUTE(A1," ","")

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.