I'm working with a large spreadsheet that has a column of cell entries that are each 14 digits long. I need to edit each cell entry in the column to eliminate the first 3 digits and last 6 digits. For example cell A2 = 00012345000R01, A3 = 00012345000R02. I need to edit the cell to return the five digits 12345. Any ideas on a macro I can write to do this for 50,000 lines of data?