There are two very similar functions in Excel to look for data inside of cells matching parameters that you dictate: SEARCH and FIND. There are so similar, in fact, that one wonders why have two separate functions that perform virtually the identical results and are identical in the construct of the formula. This article will […]
Articles Tagged: Text Formulas
5 Tips for Data Manipulation in Excel
There’s plenty you can do, if you know the correct formulas. There’s a lot of data munging you can do in a plain old Excel spreadsheet — if you know how to craft the proper formulas.
How to Define a Named Range in Excel? What are the top 3 uses of Named Ranges?
Another underused feature of Excel is Named Ranges. Named Ranges allow you to assign a meaningful name to a cell or a range of cells and then use that name instead of the actual cell reference in your formulas. A name is easier to remember when you are constructing your formulas.
How to extract initials from names in Excel?
Here I introduce few tricks to quickly extract initials from the name list in Excel, like TCS for Tata Consultancy Service and JFK for John F Kennedy. Check in here to learn how to do it.
How to Convert a Date to Calendar Quarter?
An easy formula that returns the quarter for a given date. There’s no built-in function in Excel that can do this. Check in here to learn how to do it quickly.
How to Calculate Age in Excel Accurately?
Some or the other time, we would want to calculate the Age in Excel, and more often people get frustrated as they show up a little different results than expected with A day more or less and either it shows the months completed or the current running month.
Today I will show few popular Excel Formulas in practice which will calculate the Age between given Start Date and End Date in Excel and learn how accurate they are. And also we will learn those Super Hero Formulas that gives us the accurate results!
Excel Formula to count the occurrences of text, characters, or words in a cell
Formula that will let you count how often a text character appears in a single cell? This tutorial has exactly what you’re looking for.
3 Crazy Excel Formulas That Do Amazing Things
In this article, I plan to show you how powerful formulas and conditional formatting can be, with three pretty useful examples.
Microsoft Excel: Useful Functions You Should Get to Know
In this article we’ll discuss categories of functions – what they do and various examples – and to illustrate how they work, we’ll show you several example spreadsheets. We encourage you to follow along by creating your own spreadsheets.
Why Do You Need Formulas and Functions?
If you are an office administrator, you probably use Excel. Ditto if you are a salesman. If you are a financial analyst, of course, you need Excel. For these and many other professions, working with spreadsheets is an essential tool in the daily routine.