triming the first 10 characters in a cell..

F

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Manipulating Strings in a Macro 2
deleting first 10 characters in a cell 3
Remove blanks from text 6
formating cell with TEXT data type 1
LEFT and MID 2
Wildcard Filtering on ADO Recordset 1
Eliminating cells 3
Rtrim and Ltrim with values 4

Top