Previous Topic Next Topic

Excel Macro -

Closed
Don - Jul 11, 2010 at 10:32 AM
rizvisa1 Posts 4478 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?
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses