What is the difference between SUBSTITUTE and REPLACE function in MS-Excel?
devquora
Posted On: Feb 22, 2018
The SUBSTITUTE function basically substitutes one or more instances of previous text with the new text. The syntax for this is:
Syntax: SUBSTITUTE (text, old Text, new Text, [instance Number])
Whereas the REPLACE function swaps the part of the text string with another set of text. The Syntax for this is:
Syntax: REPLACE (old Text, start Number, Number Characters, new Text)
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Microsoft Excel Interview Questions
Can you provide an overview of Microsoft Excel?
Microsoft Excel is commonly known as an electronic spreadsheet application, which facilitates the users to store, organ..
Microsoft Excel Interview Questions
Can you explain the concept of spreadsheet?
Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells...
Microsoft Excel Interview Questions
What do you mean by ribbon?
The ribbon in MS Excel is a user interface at the top, replacing traditional menus. It organizes commands into tabs like Home, Insert, and Formulas for easy access to various functions, enhancing user..