How To Check If Multiple Conditions Are Met In Excel

Sometimes, you need to check if multiple conditions are met to decide what to do next. For example, you have list of friends and you want to know what gift you will send them. Here are the options: “If they are single and over 40, you would send them book, otherwise, you will send a […]

How To Extract Parts of Date In Excel

Sometimes, you need to extract different parts of a date to do, for example, comparison. Some people may think of doing a text to column to split parts of date. However, that would not work. Even if it was, it isn’t a good method. Luckily, there are built-in methods in Excel that help you do […]

How To Count Number Of Days, Years, Months… Between Two Dates In Excel

Sometimes you want count the days, months, years… between two dates. For example, you are expecting a child and you may want to know how old he/she in terms of days, months. Well, Excel has a very useful function for this task. Let’s take a look at the DATEDIF function. How does it work? The […]

How To Extract Parts Of Text String

If you want to extract a part of text from a text string in Excel, you don’t need to look any further. With the three built in functions called LEFT, RIGHT and MID, you can extract any part of a text string you need. The LEFT function let you to extract a certain characters from […]

How To Remove Leading And Trailing Space From Text String In Excel

Often time, you may copy and paste text from the web, other sources to excel. Then, you need to do comparison between strings. In Excel cells, two strings may look similar but when you do the comparison, they are not. How so? It is because you may have leading or trailing spaces. The solution would […]

Excel Tips 1: Double Click To Copy Formula

Every Excel users, from 1995 to 2016 knows that you can move your cursor to the bottom right of a cell and drag down to copy the formula to the cells below. However, what would you do if you have, says, thousands of rows to copy the formula to? Dragging the cursor seems to be […]

How to include double quotes in Excel formulas?

In Excel, string are marked with the double quote. So, in string concatenation (joining string), you will use the double quote. For example: However, how would you join two strings which one of the contain the double quote? The trick would be using three (03) double quotes instead of one: As you can see, in […]

How To Turn Excel Into CSV With UTF-8 Support

Excel works wonderfully with UTF-8. However, when you need to send a list to other people, their computer may not have Excel installed. The solution would be turning the .xls or .xlsx file into a .csv file and send to your recipients. The convenience of the .csv is that all operation systems support it without […]