Results 1 to 2 of 2

Find nth instance of a character in a string

Threaded View

BRISBANEBOB Find nth instance of a... 12-26-2011, 06:50 PM
DonkeyOte Re: Find nth instance of a... 12-26-2011, 07:09 PM
  1. #1
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    811

    Find nth instance of a character in a string

    Mod. edit: BrisbaneBob - please don't post q's in another member's thread (no matter how old it is) - post moved to dedicated thread.

    This formula was offered as a method of finding the nth instance of "/" in a string. I have used it successfully. I have run it through Formula Evaluate to see how it works but I still can't figure it out. Can someone be kind enough to explain to me how it works?

    =RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1,"/","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

    Thanks and regards
    Last edited by DonkeyOte; 12-26-2011 at 07:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1