## Trim and Combine Spaces in Excel

If you import data from legacy systems and external databases into Excel, you most likely will find that the data contains extra spaces….

If you import data from legacy systems and external databases into Excel, you most likely will find that the data contains extra spaces….

When you work a lot with Excel, it just feels unnatural for you to use any other tool for calculations and mathematical operations….

As you are probably aware, Excel is a fantastic tool for all mathematical operations. In the program itself, different formulas can be used,…

Sometimes when you use the regular addition (+), multiplication (*), division (/), or subtraction (-) operators in the Excel formula, you get the…

Every day we deal with numbers with decimal notation, but there can be these rare occasions when we need to use other systems,…

In Excel, two functions are designed in a way to work with these types of codes: CHAR and CODE. If you want to…

If you want to calculate the time between two dates, you have to remember that’s a bit more complicated than calculating the difference…

Not very often can happen that we need to return the actual reference of a certain cell, instead of the cell value itself….

A lot of times, people are giving up on Excel because they have problems with formatting. One of the most common problems is…

So far, we showed and you are probably aware of the two cool functions- VLOOKUP and INDEX (in a combination with the MATCH…