Function: REPT

Function: REPT

REPT is a Text function that repeats a string a given number of times. It is useful for filling a cell or fixed length of strings, as well as creating simple histograms. In this guide, we’re going to show you how to use REPT function and also go over some tips and...
Function: MEDIAN

Function: MEDIAN

The MEDIAN Excel function is a Math formula that calculates and returns the median of the selected values. The median in statistics represents the middle value in a dataset. In this guide, we’re going to show you how to use the Excel MEDIAN function and also go over...
Function: TRANSPOSE

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 this function....
Function: CONCATENATE

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 and error...
Function: TEXTJOIN

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...
Function: CONCAT

Function: CONCAT

The CONCAT is a Text function that joins strings together. When using concatenate in Excel, you can enter static strings, a range of cells to join, and individual cell references. In this guide, we’re going to show you how to use the CONCAT function to merge cells in...
Function: REPLACE

Function: REPLACE

The Excel REPLACE function is a Text formula that replaces any text in a specific location with another. You can obviously use Excel’s Find & Replace tool to do this, but a formula approach will give you more options as to how you can handle this, and also...
Function: SUBSTITUTE

Function: SUBSTITUTE

The Excel SUBSTITUTE function is a Text formula that substitutes a text string with another. In this guide, we’re going to show you how to use the Excel SUBSTITUTE function, and also go over some tips and error handling methods. Supported versionsAll Excel...