What are the difference between SUBSTITUTE and REPLACE function in MS-

1.	What are the difference between SUBSTITUTE and REPLACE function in MS-Excel?
Answer» SUBSTITUTE is used to replace ONE or more instances of a text string or a character. We should use Excel Substitute function when we know the replaceable text. On the other hand, we use the Replace function in Excel for changing the CHARACTERS of a text string in a specified position. These are the BEST Interview Question and will help you get your dream job.

What are the difference between SUBSTITUTE and REPLACE function in MS-Excel?

Answer»

SUBSTITUTE is used to replace ONE or more instances of a text string or a character. We should use Excel Substitute function when we know the replaceable text.

On the other hand, we use the Replace function in Excel for changing the CHARACTERS of a text string in a specified position.

These are the BEST Interview Question and will help you get your dream job.

Discussion

No Comment Found

Related InterviewSolutions

What are the difference between SUBSTITUTE and REPLACE function in MS-Excel?
Why is VBA used in Excel?
How to sort numerically in Excel?
What is a waterfall chart in Excel?
What is pivot cache in Excel VBA?
Is there a shortcut key for AutoSum in Excel?
What is the use of subtotal function in Excel?
How do you enter a complicated formula in Excel?
What is the order of precedence for Excel operators?
How are count Counta and Countif functions different from each other?

What are the difference between SUBSTITUTE and REPLACE function in MS-Excel?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment