removing first three characters
 

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

removing first three characters
 

Hi Tiffany.

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

End Sub

---
Regards,
Norman



"Tiffany" wrote in message
...
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

removing first three characters
 

=right(a1,len(a1)-3)

T

--
Message posted from http://www.ExcelForum.com

removing first three characters
 

for each c in selection
c.value=right(c,len

--
Don Guillett
SalesAid Software

"Tiffany" wrote in message
...
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

removing first three characters
 

oops use THIS

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

"Tiffany" wrote in message
...
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