How to change the row1 content of the existing excel file automically

  • Thread starter Thread starter tlee
  • Start date Start date
T

tlee

Hi all,

I have a excel file which contains with several numbers of rows and columns
data.

Since, I need to rename the data inside the cell A1, B1, C1,D1...........

Beside, I also want to convert the content of the column of Cell AJ2 to the
end of that column such as if "H", it is converted to "1".
If "L", it is converted to "0"

How can I do if I want to change them automatically by" one click" action?

Thank you very much for your help

Tlee
 
Thanks for your information.

And How can I convert the excel file to a new excel file with revised cells
automatically?

For example:
the existing file name: Test1.xls
the converted new file name: Test1revised.xls (automatically revised cells
already)

Thanks,
Tlee
 
Back
Top