Results 1 to 3 of 3

Thread: Question on removing numbers from many cells

  1. #1

    Question on removing numbers from many cells

    Register for a FREE account, and/
    or Log in to avoid these ads!


    I have a database in excel 2010 that has a variety of id numbers like 002-A1-003. The numbers range from XXX-XX-XXX to XXXX-XX-XXX. I'd like to globally remove either the first 3 or 4 digits and copy the XX-XXX to another column. Then I can sort the data by the last 5 numbers XX-XXX. For example 002-A1-003 would transfer A1-003 to the next column. Is there an easy way to do this?



  2. #2
    Acolyte Kevin@Radstock's Avatar
    Join Date
    Oct 2012
    Excel Version
    Hi RonN

    Try the following, assuming your data is in column A, in say C1 and copy down:


  3. #3
    Thanks Kevin, I'll try it.

Posting Permissions

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