I have a macro that performs an edit on the the length of
cell. If it is more than 4 characters, it provides an
error message and stops the macro so the user can fix the
problem.

One user has entered data that is confusing. The cell is
displayed as '0599 on the toolbar. In the cell it looks
like 0599.

Another macro uses looks at the cell and takes the first 2
characters '5 and put it in a column. The macro then
takes the next 2 characters 09 and puts it in a second
column. This causes an error because we are looking for
05 and 99.

When I check the length of the variable with '0599, it is
4. I'n not sure how to work with this data. How do I
handle the tick mark (') in the first macro?

Any suggestions would be appreciated. Thanks for the help.