Split a String at a Specified Position |
Split a String at the First Occurrence of a Character |
Split a String at the N'th Occurrence of a Character |
Find | - | Returns the position of a sub-string within a supplied string (case-sensitive). |
Search | - | Returns the position of a sub-string within a supplied string (not case-sensitive). |
Len | - | Returns the length of a supplied text string. |
A | B | ||
---|---|---|---|
1 | test string | =LEFT( A1, FIND( ' ', A1 ) - 1 ) | - returns the result 'test' |
A | B | ||
---|---|---|---|
1 | test string | =RIGHT( A1, LEN( A1 ) - FIND( ' ', A1 ) ) | - returns the result 'string' |
A | ||
---|---|---|
1 | An example text string | |
2 | =SUBSTITUTE( A1, ' ', '|', 3 ) | - returns the result 'An example text|string' |
3 | =FIND( '|', A2 ) | - returns the result '16' |
4 | =LEFT( A1, A3 - 1 ) | - returns the result 'An example text' |
A | ||
---|---|---|
1 | An example text string | |
2 | =LEFT( A1, FIND( '|', SUBSTITUTE( A1, ' ', '|', 3 ) ) - 1 ) | - returns the result 'An example text' |