Thursday, December 19, 2013

How to Delete the First Five Characters in Excel 2007


1. Open your spreadsheet in Microsoft Excel 2007.
2. Locate the cell that contains the text you need to truncate.
3. Enter the following text in a new cell, replacing 'old_text' with the cell reference of the text you need to truncate.=REPLACE(old_text,1,5,'')As an example, to delete the first five characters from cell A1, you would enter:=REPLACE(A1,1,5,'')Alternatively, you can replace 'old_text' with the actual text encased in quotes. As an example, to delete the first five characters from the text 'truncate me!,' you would enter:=REPLACE('truncate me!',1,5,'')

Blogger news