triming the first 10 characters in a cell..

[dstiefe]

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

Thank you

 

[FSt1]

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

 

[Bernie Deitrick]

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