REMOVE 3 DIGIT FROM LEFT OR RIGHT IN EXCEL SHEET

To remove the first three digits from a number in an Excel sheet, you can use the RIGHT function. Here’s how you can do it:

Steps:

1. Suppose the number is in cell A1, and you want to remove the first 3 digits from it.
2. In a new cell (e.g., B1), enter the following formula: =RIGHT(A1,LEN(A1)-3)

Explanation:

• LEN(A1) gets the total number of characters in the number.
• LEN(A1)-3 calculates the number of characters remaining after removing the first 3 digits.
• RIGHT(A1, LEN(A1)-3) extracts the remaining characters from the right.
• LEFT(A1, LEN(A1)-3) extracts the remaining characters from the left.

This formula works well for numbers in text format or numbers stored as text. If the value is numeric, you might want to convert it to text first, or adjust the formula depending on how the data is stored.