If you're trying to get a part of a text from a excel's cell, this post can help you with a few samples.
For all examples we need a delimited char to split our text in two parts, nedeed and needless.
For this example, the comma , is our delimited char. Now, you can eliminate all right side (needless text).
For this example, the comma , is our delimited char.
Get all right text (needed text) from that char.
Use trim function to remove needless spaces
First of all you could eliminate the right needless part of the text.
Then we will eliminate all left side from searched text. On our example, we will use slash char / to split our text.
If you've found a typo, a sentence that could be improved or anything else that should be updated on this blog post, you can access it through a git repository and make a pull request. If you feel comfortable with github, instead of posting a comment, please go directly to https://github.com/campelo/documentation and open a new pull request with your changes.