+ Reply to Thread
Results 1 to 5 of 5

formula to place text, beginning from 4th slash from right

  1. #1
    Registered User
    Join Date
    06-02-2014
    Posts
    88

    formula to place text, beginning from 4th slash from right

    Hi,
    Do you know how to work out formula to provide with cell reference, beginning from the first digit shown up?


    Original cell vaule:
    K:\PodrecznikOperacyjny\MKrawczynski\HandBook\1.Kontroler lukowy\1.Przygotowanie do pracy\1.1.Przygotowanie do pracy w budynku\4. pobranie radia i baterii z controlroom'u.jpg

    Referenced cell value - is value that shows up reference beginning when the first digit shows up
    1.Kontroler lukowy\1.Przygotowanie do pracy\1.1.Przygotowanie do pracy w budynku\4. pobranie radia i baterii z controlroom'u.jpg

    Regards,
    Marcin Krawczynski
    Last edited by Marcin4111; 12-01-2014 at 06:28 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,977

    Re: formula to place text, beginning from 4th slash from right

    Hi there. This is a bit of a monster, but does do what you want.

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



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

    Re: formula to place text, beginning from 4th slash from right

    Glenn, you can avoid ISERROR part if you add number array after A1:

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


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

    for eabove example.

    Marcin4111, if you get error replace ; with ,

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

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,977

    Re: formula to place text, beginning from 4th slash from right

    Zbor: thanks!

  5. #5
    Registered User
    Join Date
    06-02-2014
    Posts
    88

    Re: formula to place text, beginning from 4th slash from right

    Thank you guys, works great!

+ 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. How do you remove all text before the last forward slash?
    By lukesmith7 in forum Excel General
    Replies: 7
    Last Post: 05-22-2014, 07:59 AM
  2. How do you remove text before the last forward slash?
    By lukesmith7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-22-2014, 07:31 AM
  3. [SOLVED] Script or formula to move text from beginning to end of a string
    By robbyvegas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-11-2012, 10:18 AM
  4. Separating Text on either side of a slash
    By andrewplatham in forum Excel General
    Replies: 5
    Last Post: 10-05-2010, 01:56 AM
  5. Taking text after slash
    By brendan1 in forum Excel General
    Replies: 2
    Last Post: 02-24-2009, 02:45 PM

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