Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to strip of 4 left most characters in a text string in calc

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.

How to strip of 4 left most characters in a text string in calc

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.