How to Use Microsoft Excel to Trim All Characters To The Right Of…
How to Use Microsoft Excel to Trim All Characters To The Right Of The First Occurrence A Specific Character:
This is a handy technique to trim all content in a cell that appears to the right of a particular character. For instance, to delete all content to the right of the first left parenthesis in the A1 cell:
=LEFT(A1|FIND(“(“|A1)-1)
Replace the character in the double quotes witht the character that is to be found and trimmed out along with all text to the right of it.
To trim all text to the right of, but not including the character, remove the -1 from the formula equation.
Posted under Uncategorized
This post was written by Content Curator on October 31, 2009
