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:
Dim bCell As Range
Dim cutRange As Range
cutRange = Range("B2:B30000")
For Each bCell in cutRange
If bCell.Left(1) = "-"
bCell = bcell.Right(len(bCell)-bCell.Left(1))
End If
Next
This code obviously does not work/compile. Any help is appreciated.
Thank you.
Bookmarks