perfect. Thanks so much.
I have another sheet. Similar scenario except i just want it to ignore the last digit?
Can you tell me this formula?
Thanks
No worries. Try to play around with the LEFT, RIGHT and LEN functions. Really nice for string manipulation.Thank you very much for your help.