Function: SEARCH

Function: SEARCH

Excel SEARCH function returns an integer that represents the position of a specified character or substring within a text. In this guide, we’re going to show you how to use the Excel SEARCH function and also go over some tips and error handling methods.Supported...
Function: FIND

Function: FIND

Excel FIND function returns an integer that represents the position of a specified character or substring, within a text. In this guide, we’re going to show you how to use Excel FIND function, and also go over some tips and error handling methods.Supported versionsAll...
Function: MID

Function: MID

The MID function returns a sub-string from a string, starting from a specified location. In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel MID...
Function: RIGHT

Function: RIGHT

The RIGHT function returns a sub-string from a specified string, starting from the right-most character. In this guide, we’re going to show you how to use the Excel RIGHT function and also go over some tips and error handling methods.Supported versionsAll Excel...
Function: LEFT

Function: LEFT

The LEFT function returns a sub-string from a specified string, starting from the left-most character. In this guide, we’re going to show you how to use the Excel LEFT function and also go over some tips and error handling methods.Supported versionsAll Excel...
Function: PROPER

Function: PROPER

The PROPER function capitalizes the first letter of each word and converts the remaining letters into lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods.Supported versionsAll Excel...
Function: LOWER

Function: LOWER

The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods.Supported versionsAll Excel versionsSyntax LOWER(text)ArgumentstextThe text you want converted...
How to replace character in Excel by position

How to replace character in Excel by position

This article shows how to replace character in Excel by position using REPLACE function. If you are looking to replace a specific character please refer to article How to replace a character. Syntax =REPLACE( text, start position of replacement, number of characters...
How to replace characters in Excel

How to replace characters in Excel

Excel’s built in find and replace feature is fairly useful in most cases. But this can get tedious if you’re working with a large workbook or want to set this up dynamically. In this article we’re going to show you how to replace characters in Excel...