Results 1 to 3 of 3

Thread: How to delete first 4 letters of Cell in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    70

    How to delete first 4 letters of Cell in Microsoft Excel

    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.

  2. #2
    Join Date
    Jun 2011
    Posts
    487

    Re: How to delete first 4 letters of Cell in Microsoft Excel

    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)) .

  3. #3
    Join Date
    Nov 2010
    Posts
    422

    Re: How to delete first 4 letters of Cell in Microsoft Excel

    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)

Similar Threads

  1. Replies: 2
    Last Post: 23-02-2012, 07:23 PM
  2. Cell borders are missing in Microsoft Excel
    By GuruT in forum MS Office Support
    Replies: 6
    Last Post: 13-01-2012, 06:08 PM
  3. excel: delete (or find) cell if it meets certain criteria
    By cmendes in forum Windows Software
    Replies: 3
    Last Post: 12-11-2011, 12:14 PM
  4. Replies: 6
    Last Post: 23-07-2011, 01:05 AM
  5. Based on Cell Criteria Delete Row in excel
    By AlpAnA$ in forum Windows Software
    Replies: 5
    Last Post: 09-07-2011, 08:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,642,356,812.67233 seconds with 18 queries