**Microsoft Excel** is a powerful spreadsheet application that is widely used for organizing, analyzing, and presenting data. One common task that users often need to perform in **Excel** is removing the first five characters from a cell’s contents. This can be useful when dealing with large datasets that have extraneous information at the beginning of each cell.

Here we have a dataset above related to automobiles, in this dataset there are some useless characters in the beginning of the **Year **column. In this tutorial we will learn how to remove these characters using two different methods in the **Sorted Year** column by following the steps below but first letâ€™s have a look at the dataset.

## Method 1: Using the RIGHT Function

## Step 1 – Type the RIGHT Formula

- Select the cell where you want to type the Formula.
- Syntax of the formula will be:

**=RIGHT(Cell_Address,LEN(Cell_Address) – Number_of_Characters_to _Remove)**

- In our case formula will be:

**=RIGHT(C2, LEN(C2) – 5)**

## Step 2 – Find the values for the rest of the cells.

- Select the cell with formula.
- Drag it from bottom right to the remaining cells.
- Formula will be applied automatically.

## Method 2: REPLACE Formula.

## Step 1 – Type the REPLACE Formula.

- Select the cell where you want to type the formula.
- Syntax of the formula is:

**=REPLACE(Cell_Address,Start_of_range,End_of_range, “Value_to_Replace_with”)**

- In our case the Formula will be:

**=REPLACE(C2,1,5,””)**

## Step 2 – Find values for the rest of the cells.

- Select the cell with formula.
- Drag the cell from bottom right to the rest of the cells.
- Formula will be applied automatically.