removing first three characters

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

I need to remove the first three characters from a string
of text for example


tbwGo_Home - I would like the result to be Go_Home
 
Hi Tiffany.

Sub Tester()
Dim sStr As String
sStr = "tbwGo_Home"
sStr = Mid(sStr, 4)
MsgBox sStr

End Sub
 
oops use THIS

Sub deleteleftthree()
For Each c In Selection
c.Value = Mid(c, 4, Len(c) - 3)
Next
End Sub
 

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

Back
Top