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

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

Formula:

Please Login or Register  to view this content.

Zbor: thanks!