Left/Right function in VBA, finding a specific starting character

Hello,

I have a worksheet in which I would like to go through column B and see if any cells in column B start with a "-" character. If they start with "-" then I would like to remove it from the cell. I've been trying to use the left function in several different ways but nothing has worked for me.

Examples of what I tried:

Please Login or Register  to view this content.

This code obviously does not work/compile. Any help is appreciated.

Thank you.

I figured out the code:

Please Login or Register  to view this content.

Patel45 thank you. Your code is also correct.