How to Delete Characters Over 40 Character Length in Excel

1. Click the 'Start' button on the taskbar, type 'Microsoft Excel' in the Search box and then press 'Enter.'
2. Press 'Ctrl O' and then choose the Excel document from which you want to delete characters over 40 characters in length on the dialog box that opens.
3. Type the formula '=LEFT(cell_number,40)' in the cell in which you want to delete characters over 40 characters in length. Replace, cell_number with the unique number of the cell, for example, A1.