Thread: Partial String
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rowan Drummond
 
Posts: n/a
Default Partial String

Try:

Dim myStr As String
Dim myNewStr As String
myStr = "67890 / 1111"
myNewStr = Mid(myStr, InStr(1, myStr, "/") + 1, Len(myStr))
Debug.Print myNewStr

If want the backslash included in the result then you would remove the
"+ 1" but you would then need to include some error handling incase your
string did not contain "/".

Regards
Rowan

mjack003 wrote:
That works great but I don't think I was very clear. I need everything
after the "/" backslash. So is there a way to omit everything before
that character and save only the remaining part?

Thanks for the input,

Mjack