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
Comments are closed.
More Articles:
Next Post: Adobe Download: Adobe Reader 9.1
Previous Post: Windows XP Service Pack 3 Command Line Options