Excel Macro -

Closed
Don - Jul 11, 2010 at 10:32 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 13, 2010 at 07:29 AM
Hello,

I deal with spreadsheets in which I want to modify the data in column A.
I need to delete the first 9 characters of each cell.

The column is of varying lengths from sheet to sheet - so I guess I need to count the number of used cells first.

I use Excel 97 and/or 2003

Any suggestions?

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 13, 2010 at 07:29 AM
delete first 9 characters of each cell in every sheet ? or each cell in column A of every sheet or some thing else?
0