Function: TRUNC
The Excel TRUNC function is a Math formula that truncates a given number by removing a number of digits. Although, it is similar to the INT function, the TRUNC function works differently when truncating negative numbers. In this guide, we’re going to show...
How to get top values from a list or a table in Excel
Sorting data can substantially help organizing data and generating reports. In Excel, you can sort data with a single click using the Sort icons under the DATA tab. However, this is a permanent solution, meaning that the sorted data will remain that way,...
Function: TRANSPOSE
The TRANSPOSE Excel function is a Lookup & Reference formula that rotates a given range or array. Since the output of this formula is an array, you need to press the Ctrl + Shift + Enter (CSE) key instead of just pressing the Enter key when entering...
Function: CONCATENATE
The CONCATENATE Excel function is a Text formula that joins multiple strings together. You can enter static strings and individual cell references. In this guide, we’re going to show you how to use the CONCATENATE Excel function and also throw in some tips...
Function: TEXTJOIN
The TEXTJOIN Excel function is a Text formula that joins strings together with a delimiter. You can enter static text strings, a range of cells, and individual cell references to join. In this guide, we’re going to show you how to use the Excel TEXTJOIN function and...
Excel Function: SUBSTITUTE
The SUBSTITUTE function in Excel is a powerful tool for manipulating text strings by replacing specific instances of a substring with another. This function is particularly useful when you need to replace certain characters or words within a cell with something else....
How to Use Excel SMALL Function
The Excel SMALL function is a Statistical formula that sorts numbers in a list from smallest to largest and then gives you the number that is in a certain position. In short, it returns the kth smallest value in a list. In this guide, we’re going to show you how to...
How to filter by using a formula in Excel
Filtering data helps focusing on certain aspects of a data set. Excel has built-in features for this, an Excel formula for filtering data was not in the software's scope until the introduction of dynamic array functions. In this guide, we’re going to show...
Excel TRIM Function
The Excel TRIM function is a very useful tool in text manipulation in Microsoft Excel. Essentially, this text formula is adept at cleaning up text strings. It skillfully removes any unnecessary leading and trailing spaces from your data, ensuring your text is neat and...