Question on removing numbers from many cells

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

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

Thanks Kevin, I'll try it.