I need to delete the last two numbers shown in a series of cells. I can split the numbers at the hyphen if need be but second set of numbers needs to have the last two numbers eliminated (without the obvious backspacing). Copy of data:
000103-03101
000103-03102
000503-04601
000503-04701
001103-00601
000023-02901
000023-03001
000023-03002
000023-03003
For example: 000103-03101 needs to show 000103-031. I realize there will be duplicate cells. Please advise. Thanks.
Bookmarks