In this tutorial, you will learn how to remove first 3 characters from string in Excel.
When working with raw, unstructured data, we often need to extract relevant information from it. You may need to remove the first, second, or third character from a text string to get the value. Excel has several features that you can use to complete this kind of task. You can also create custom functions to remove characters from text strings.
Once you are ready, we can start by using real-life scenarios to help you understand how to remove first 3 characters from string in Excel.
Table of Contents
Anatomy of RIGHT Function
RIGHT(text,[num_chars])
RIGHT function is a text string function that returns the number of characters from the right side of a string. Useful for extracting characters from rightmost to leftmost.
Anatomy of LEN Function
LEN(text)
LEN returns the length of a text string in characters.
Remove First 3 Characters from String
Before we begin we will need a group of data to be used to remove first 3 characters from string in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
To remove the first 3 strings in a cell, we can use the following formula =RIGHT(A2,LEN(A2)-3).
Step 3
Once we are done, you will be able to remove first 3 characters from string.
