Macro to Delete all but first 3 characters

Hi,

I have a table that I am importing into Excel from accounting software. The spreadsheet that contains the imported data has a tab for each month of the year. The column headers in row 1 currently have a three digit location number followed by the location name. The columns are too wide with the full location name.

I want to include a macro that will run on the active tab in the worksheet to delete all characters in the column headers except for the three digit location number. The very last column contains totals and must be excluded. We are constantly adding new locations and closing old ones, so the number of columns of data will change month by month and I do not want to have to modify the macro when that happens. It must run on the active tab in the worksheet so it can be run on a new tab each month.

Thanks in advance for your help!

Hi

Try

Please Login or Register  to view this content.

rylo