How to delete first 4 letters of Cell in Microsoft Excel

[Ulrich]

Hello, I want to delete the first four characters in a cell, for example, in this MRS. Mary Johnson, I want to delete MRS. I tried "left, and mid function but I must be doing something wrong. Any help would be appreciated.

[GALIENA]

There are certain references that can help you. Below are some formula that you can try in excel cell to get rid of starting letters of text in Microsoft Excel.

=RIGHT(A5,LEN(A5)-5) or =RIGHT(A5,LEN(A5)-FIND(" ",A5)).

On the face of it, this might suffice With data in A1 down In B1, copied down: =TRIM(MID(A1,5,99)) .

[Alfons]

Follow the below steps:

• If you really just want to delete the first four characters, then: =REPLACE(A1,1,4,"").
• If you also want to delete any leading spaces, left over, as there would be, then with your example:=trim(REPLACE(A1,1,4,"")).
• If you want to delete everything up to and including the first space (i.e. the first word), then: =MID(A1,FIND(" ",A1)+1,255)