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