Table of Contents
To remove the first three characters from a string in Excel, you can use the LEFT function. This function allows you to specify the number of characters to extract from the beginning of the string. By using the LEFT function with a specified number of characters of 3, you can easily remove the first three characters from the string. This can be useful for cleaning up data or extracting specific information from a larger string.
Excel: Remove First 3 Characters from String
Often you may want to remove the first 3 characters from a string in Excel.
You can use the RIGHT function combined with the LEN function to do so:
=RIGHT(A2,LEN(A2)-3)
This particular formula removes the first 3 characters from the string in cell A2.
The following example shows how to use this formula in practice.
Example: Remove First 3 Characters from String in Excel
Suppose we have the following list of basketball team names:
Suppose we would like to remove the first three characters from each team name.
We can type the following formula into cell B2 to do so:
=RIGHT(A2,LEN(A2)-3)
We can then click and drag this formula down to each remaining cell in column B:
Column B now displays the team names in column A with the first three characters removed from each team name.
How This Formula Works
The RIGHT() function in Excel extracts a specific number of characters from the right side of a string.
The LEN() function in Excel is used to find the length of a string.
Thus, our formula displays the entire string with the first three characters removed.
Note: Blank spaces at the start of a string count as characters. You may need to first remove blank spaces to get your desired result.
The following tutorials explain how to perform other common tasks in Excel:
Excel: A Formula for MID From Right
Excel: How to Use MID Function for Variable Length Strings
Cite this article
stats writer (2024). How can I remove the first three characters from a string in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-remove-the-first-three-characters-from-a-string-in-excel/
stats writer. "How can I remove the first three characters from a string in Excel?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-remove-the-first-three-characters-from-a-string-in-excel/.
stats writer. "How can I remove the first three characters from a string in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-remove-the-first-three-characters-from-a-string-in-excel/.
stats writer (2024) 'How can I remove the first three characters from a string in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-remove-the-first-three-characters-from-a-string-in-excel/.
[1] stats writer, "How can I remove the first three characters from a string in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I remove the first three characters from a string in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.