SUBSTITUTE

Replaces existing text with another text.

Syntax

=SUBSTITUTE(text,old_text,new_text,[instance_num])

Example

=SUBSTITUTE(A2,”Pvt Ltd”,”Private Limited”)

Result

Sircl Tech Pvt Ltd

↓

Sircl Tech Private Limited

REPLACE

Replaces text based on character position.

Syntax

=REPLACE(old_text,start_num,num_chars,new_text)

Example

A2 = EMP2025001

=REPLACE(A2,4,4,”2026″)

This replaces the characters at the specified position.

Difference

SUBSTITUTE → Finds old text and replaces it.

REPLACE → Replaces text based on its position.

Practice

In customer/company data:

  • Pvt Ltd → Private Limited
  • Old year → New year
  • Incorrect code → Correct code
PreviousNext