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

Function: HYPERLINK

The Excel HYPERLINK formula is a Lookup & Reference function that can establish a connection to an external source such as a specific website, location in the document, or a different document. In this guide, we’re going to show you how to use the Excel HYPERLINK...
Function: LARGE

Function: LARGE

The Excel LARGE function is a Statistical formula that returns largest value in an array or a range. In this guide, we’re going to show you how to use LARGE function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel LARGE...
Function: SMALL

Function: SMALL

The Excel SMALL function is a Statistical formula that returns the smallest value in an array or a range. In this guide, we’re going to show you how to use the Excel SMALL function and also go over some tips and error handling methods. Supported versionsAll Excel...