I am building an excel address parser.
Column B = streetnumber
Column C = UnitNumber
Column B is my streetNumber and What I need it to do is anytime it finds a letter attached to the number it needs to move it from column b to column C.
So if it ended up on B435 how do I get that value of "A" to be on C435
Try If (xlWorkSheet.Range("b2:b25000").Find(What:="a")).Count > 0 Then xlWorkSheet.Cells.Replace(What:="a", Replacement:="") End If Catch ex As Exception