Remove Last 2 Characters in a Column of Data

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

How about this macro for removing characters from selected cells:

Please Login or Register  to view this content.

Originally Posted by tom1977

try

=left(A1,len(A1)-2)

Perfect, Thanks