Question on removing numbers from many cells

[RonN]

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

[Kevin@Radstock]

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

[RonN]

Thanks Kevin, I'll try it.