how do i trim or erase the first 10 characters in a cell?

Thank you

hi
short answer..
Sub trimit()
Dim r As Range
Set r = ActiveCell
r.Value = Right(r, Len(r) - 10)
End Sub

do we have more than one cell???

regards
FSt1

"dstiefe" wrote:

how do i trim or erase the first 10 characters in a cell?

Thank you

Sub Trim10()
With Activecell
.Value = Mid(.Value,11,Len(.Value))
End With
End Sub

or

Sub Trim10B()
With ActiveCell
.Value = Mid(.Value, 11)
End With
End Sub


HTH,
Bernie
MS Excel MVP


"dstiefe" wrote in message
...
how do i trim or erase the first 10 characters in a cell?

Thank you