Professional Development Work Hacks

Excel: Remove Everything After a Character (like a question mark, comma or underscore)

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