REPLACE Function in Excel

Home/Excel Formulas/REPLACE Function in Excel

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
By |April 11th, 2013|Excel Formulas|1 Comment

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

One Comment

  1. manish September 11, 2014 at 9:09 PM - Reply

    Kindly Please provide

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.