What is the use of REPLACE function?

REPLACE function replaces a sequence of characters/words in a string with another set of characters/words

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


What is the syntax of REPLACE function?

REPLACE Function in Excel - syntax
REPLACE(old_text,start_num,num_chars,new_text)

Where:
old_text: actual string value
start_num: position in old_text to begin replacing characters
num_chars: number of characters to replace in old_text
new_text: replacement set of characters

REPLACE Function in Excel – Examples

REPLACE Function in Excel Examples

Reference:

Please refer the below article for more Text Excel functions.
Text Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

LIMITED TIME OFFER - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference