In my early days of using excel, I knew not what concatenate was. If I needed to combine text from two cells, I would manually copy from each cell and combine in a new cell. That was until my colleague told me about Concatenate function. I was fascinated, and going forward I dedicated my time … Read more
The Excel count function returns the number of entries in a number field in a range. This means that only numbers would be counted within the range selected. These could be positive or negative numbers, percentages, dates, time, fractions, and even formulas that output numerical values. However, empty cells and text values are ignored. Now … Read more
The excel mid function is used to extract a specified number of characters from a text string. The user is able to dictate the start and end point of the extracted characters. For example if the MID function is used for a text string: =MID(“mango”,4,2), it returns the word “Go”. This is because the first … Read more
Paste special in excel is a must know for every user of excel, especially those using this powerful software for financial modelling. The first leg is always copying the data (Ctrl + C) and the second leg is deciding what to do with the copied data using the paste special options. You could choose to … Read more
