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!

    hello,

    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?

    Thanks,

    RonN

  2. #2
    Hi RonN

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

    ​=MID(A1,FIND("-",A1)+1,LEN(A1))

  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
  •