Remove characters in an excel file

[teknomatika]

I have an excel file. In a particular column i have a few hundred lines. In each cell I have a set of 9 characters. I have need to remove the first 5 characters of each cell. In Excel there are some functions to remove characters to the left or right, but this can only be done cell by cell.

My question: Does anyone know or have a Lisp routine that allows you to automate this task?

[eldon]

Can you not use the RIGHT function in Excel? Once you have written the function for one cell, then you can copy down the function to all lines in a very short time, by dragging the square

[Organic]

I'd do as eldon suggested. You could write a VBA script although it is a lot more work than the above solution.

[SLW210]

This doesn't look like an AutoCAD question, so I moved it to the Catch All forum.

[teknomatika]

Thanks for your help and clarification.