# remove the first letter in each cell in a column

#### AnnaPanna

##### Board Regular
Hi All,

I have a list with a column where all cells begins with the letter D. I would like to remove that D from all cells. For instance;

Dxxx1
Dxxx2
Dxxx3
Dxxx4

Should be;

xxx1
xxx2
xxx3
xxx4

How can I do that in a fast and easy way?

Thank you!

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### xld

##### Banned
Code:
``````With Activesheet

LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row

For i = 1 To LastRow

.Cells(i, "A").Value = Right(.Cells(i, "A").Value, Len(.Cells(i, "A").Value)-1)
Next i
End With``````

#### shyrath

##### Active Member
if the string is in A1 use this in B1

Code:
``=RIGHT(A1,LEN(A1)-1)``

#### AnnaPanna

##### Board Regular
Is this the easiest way...

Im not familiar with those formulas. Can I do it in another way?

#### AnnaPanna

##### Board Regular
Super Shy. THanks!

#### Mr. Walnuts

##### Board Regular
Your easiest method is what Shyrath said;
find an empty cell, type the following formula in it, then once its in there, then you can put the mouse cursur over the bottom right corner of that cell and drag that same formula down and it will auto-fill all the cells below it with the formula except it will reference the second, third, forth, etc cell below the one in the original formula.

=RIGHT(A1,LEN(A1)-1) <--- replace "A1" with the name of the first cell in the column.

Once you drag the formula down (drag it from the box in the lower right corner of the cell), the next cell will autofill with the formula:
=RIGHT(A2,LEN(A2)-1)

so on and so forth

It is defintely the easiest way without using VBA; plus it eliminates needing to type the formula in each box, only the first one... then drag it down to autofill

Last edited:

#### shyrath

##### Active Member
Super Shy. THanks!

welcome, but it´s the same formula as what Mr Walnuts said, only his is the Visual Basic method, which means you can do it by running a macro / button. Which is, by far, actually the quickest way and doesn´t need an extra column.

#### pgc01

##### MrExcel MVP
Hi

A simple way to remove the first letter from the cells in a column is to use Text to Columns and skip the first character.

Notice that this method does not use formulas nor vba and does not need an auxilliary column.

#### hardeep.kanwar

##### Well-known Member
If Its Always D

CTRL+H

Find What -D
Replace With -Blank
Then< Ok

Hardeep kanwar

#### shyrath

##### Active Member
If Its Always D

CTRL+H

Find What -D
Replace With -Blank
Then< Ok

Hardeep kanwar

I´m afraid that would also remove D if it´s in the middle of a word. Not just the first one.

I think pgc01 wins with the text to column one ( i didn´t know that would work! ) I tested that, and you could also use "D" as the delimiter. (if you have the room for it, as it will try and fill to the next column ofcourse).

Replies
1
Views
547
Replies
9
Views
262
Replies
5
Views
203
Replies
1
Views
91
Replies
3
Views
271

1,191,287
Messages
5,985,762
Members
439,981
Latest member
ofori francis

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back