macro to edit cell contents

[imported_unknown]

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?

 

[Juan Pablo González]

Use Data | Text To Columns, with "Fixed With". You can make the 3 groups (1-3, 4-8,9-14), and "skip" the first and third columns.

You could also use a formula in an adjacent column, and then copy and paste as values.

 

[imported_unknown]

Thank you very much. That was too easy! I was making it much harder than it needed to be. Excel has so many tools, and I'm only scratching the surface. Thanks again.