LibreOffice 4.3, English, Calc
Windows 8, English
I am using =LEFT($J69;FIND(" “;$J69;1)-1)
and =RIGHT($J69;LEN($J69)-FIND(” ";$J69))
to separate first and last name by detecting a space between them but then what would work to strip off the 4 left most characters like this one where the total length is unknown. /f/u/fuji_classic_track_2.jpg
The fourth character from the left is always a “/”.
Thanks for the help.