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