Excel Macro -

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
delete first 9 characters of each cell in every sheet ? or each cell in column A of every sheet or some thing else?