Thursday, October 18, 2012

How to Remove Everything After a Character in Excel 2007


1. Start Excel 2007. Open the worksheet you want to use by clicking 'Open' in the menu linked to the round 'Office' button.
2. Identify the cell you want to trim. The cell's name is a combination of the letters printed across the top row of the worksheet and the numbers printed at the leftmost column. By default, the first cell in your spreadsheet will be 'A1.' The currently selected cell is always listed just above the first row containing the cell labels.
3. Choose a blank cell close to the cell you want to remove characters from and click on it to make it the currently active cell.
4. Type '=LEFT(' followed by the name of the cell you want to trim, a comma, and 'SEARCH(.' For example, if you want to trim the contents of cell 'A1,' you would write '=LEFT(A1,SEARCH(.' The Excel 2007 formula bar, which is located immediately to the right of the cell label, shows you the formula you're currently writing.
5. Write the final character you want preserved, making sure to put it between quotes, and then type a comma, the name of the cell again and two closing parentheses. For example, if cell 'A1' contains the phrase 'abcefg' and you want to remove everything after the letter 'c,' the formula bar should read '=LEFT(A1,SEARCH('c',A1)).'
6. Hit the 'Enter' key.

Blogger news