I have a column containing data (numbers) with an inconsistent length (between 6 and 12 characters). I want to remove the last 2 characters from each cell in the column. I have tried the right function, and it will take the last 2 out and put in a new column, but leave them in the original column also. I have tried "split cells" and it will not let me split from the right. This would work if I was trying to remove the first 2, or if all of the cells had the same number of characters.

I want these last 2 characters completely gone.

BTW I need to do this repeatedly and possibly include in a macro

Please help