If you’re looking to use Excel to trim off everything to the right of a question mark, including the question mark (useful for trimming query strings off of URLs), you can use the following formula:
=LEFT(A1, FIND("?", A1&"?")-1)
A1 is the cell that contains the original string.
If you want to use this for a non-URL string, replace the ? with the character you’re looking for.
Read Next: Alexa: The Ultimate Guide to Amazon’s Virtual Assistant