If you want to use a formula to split a text string at the first space, and then return the right (the end) part of the string, this can be done by combining the Right function with the Excel Find function and the Excel Len function. Subtracting 1 from this value gives the value 4, which is then supplied to the Left function.Įxample 2 - Return Text From the End of a Text String In the above formula, the Find function returns the value 5 as the position of the space within the supplied text "test string". If you want to use a formula to split a text string at the first space, and then return the left part of the split string, this can be done by combining the Left function with the Find function. Split String at a Specific Character - Examples Example 1 - Return Text From the Beginning of a Text String, Up to the First Space
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |