Question on removing numbers from many cells

RonN

New member
Joined
Nov 19, 2012
Messages
3
Reaction score
0
Points
0
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

New member
Joined
Oct 5, 2012
Messages
52
Reaction score
0
Points
0
Excel Version(s)
365
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))
 
Top