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