This formula works great! But, can you explain/translate the formula?

"Barb Reinhardt" wrote:

Here's an equation to do it in helper column

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

Do you need it in a macro?

"rojobrown" wrote:

How do you remove the last two digits in a cell using a macro?

--
Thanks a bunch!
rojobrown