+ Reply to Thread
Results 1 to 2 of 2

Getting string from end until the first character apperance

  1. #1
    Registered User
    Join Date
    04-17-2015
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    1

    Getting string from end until the first character apperance

    Hello,

    How do i get only the string "Hello John" from that URL

    https://xxxx.xxxx.xx/xxxx/xxxx/Hello John

    I want to find the first occurance from the right to the left on the "/" character and extract that text.

    Preferencly without using the number of characters because the URL may change

    Thanks,

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,627

    Re: Getting string from end until the first character apperance

    Here, use this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    (replace ; with , if getting error)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] if a string doesn't contain a character insert that character.
    By LenaK in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 01-31-2015, 12:54 PM
  2. [SOLVED] find the character position in a string of the last occurrence of a nominated character
    By jmac1947 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2014, 11:52 PM
  3. [SOLVED] Apperance of selected items from drop down list in different cell
    By pointman787 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-25-2012, 12:28 PM
  4. Replies: 2
    Last Post: 06-16-2010, 09:01 AM
  5. Function to return Character Position of Xth character within a string
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2005, 11:05 AM

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