LEFT, MID, RIGHT are some of the most useful text function in Excel. They allow us to extract a specified number of characters from a text string. Yet, normal LEFT, MID, RIGHT only work in a single cell. To perform
CONCATENATE Function is a crucial function to structure data according to your needs. Reverse concatenate in Excel is equally important since sometimes you might want to split one cell into multiple cells. However, there is no such function as unconcatenate
Practice makes Perfect. When you learn about new Excel formula, you would absolutely need resources to help you consolidate this new knowledge, and to apply it to real-life, tangible examples that you can think deeper as to the meaning of
The first time I hear about =SUMIFS() was at the computer literacy class in college. The instructor tried using some data in Excel to illustrate how it works, but just like most of the class, I had no clue about why this formula matters. It was just like trigonometry to
