Results 1 to 3 of 3
  1. #1
    CLB
    Guest

    Deleting Initial numbers in cells

    I need to delete the first 5 digits of student ID #s for over 140 students. The ID#s are in their own cells. How can I automate this process (I do not want to manually edit each cell).

    Thank you.

    CLB

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Deleting Initial numbers in cells

    The following formula will work but it will produce an error if the value it is looking up is less than 5 characters long.

    =RIGHT(A1,(LEN(A1)-5))

    Tony

  3. #3
    CLB
    Guest

    Re: Deleting Initial numbers in cells

    Thank you. That worked wonderfully.

    This board works with amazing speed.

    CLB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •