Thread: How to get rest of characters after last certain character?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_284_] joel[_284_] is offline
external usenet poster
  
Posts: 1
Default How to get rest of characters after last certain character?
Use INSTRREV

string = "dummy1\dummy3\cat\test"
string = mid(string,instrrev(string,"\") + 1)

The instrrev will find the position of the last back slash in the
string. You add one to get everything after the last back slash.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=158814

Microsoft Office Help

Reply With QuoteReply With Quote