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

45 Quick Time Saving Excel Keyboard Shortcuts You Must Know

-
There are hundred of Excel keyboard shortcuts which are important and can save lots of time however, few of them are very important. Also, knowing all the shortcuts are never easy but few important ones can easily be memorized. Whether it is jumping from one cell to another, expending selections, accessing ribbon commands or printing spreadsheet, almost everything in Excel can be controlled with the keyboards. In this article, I am going to talk about some  45   Quick Time Saving Excel Keyboard Shortcuts  that can increase your productivity by 30% to 40%. Read more.....
Read more