What is the use of Substitute Function and how we can use of it

-
Excel SUBSTITUTE Function can be used to replace one or more instances of any specific character or sub string in a give text string. The function is case-sensitive and does not support wild-card characters as well.



Comments

Post a Comment

Popular posts from this blog

Data Analytics Vs Data Science

-
With data becoming the New Money, mastering the trade of Data Science or Data Analytics has become of prime importance. Though Data science may be the tree, understanding & mastering Data analytics is a feat in its own genre. With “the coolest job of the century” title, becoming a Data Analyst helps you to open multitudes of prospects which helps you in shaping your future in Data analytics. Read More...
Read more

Loan Amortization Schedule Template in Microsoft Excel

-
An  Loan Amortization Schedule  which is also known as mortgage or loan schedule, is a list of payments that shows each loan repayment and a breakdown of the principle amount and the interest. It shows the breakdown so that you can see how much is going toward the principle and interest each month.  Apart from this, the schedule also shows the remaining balance after each payment has been made. In other words, it calculates your monthly loan repayment and lets you know how much of your monthly installment will go towards the principle and how much will be paid for interest. Read More....
Read more