Return the column number based on the column address

[SouthKaDaaku]

I have a sheet that has many words that occur multiple times. By running a macro, I could determine the following:
1) the words that repeat
2) the number of times those words repeat
3) the placement/address of every instance of those repetitive words.

Now, based on the address of those words, I want to generate a column number. For example, if a word "HELLO" is present in Cell AZ4, I want a solution that tells me that AZ4 is in column 52.

Please note that I have multiple instances of multiple words. Sharing a screenshot of the data for better understanding.

 

[Debaser]

Range("AZ4").Column

would return 52.

 

[p45cal]

1.

By running a macro

Let's see the code of this macro.
2.

I want to generate a column number

Where do you want to see these column numbers to appear? Note also that there will be multiple column numbers per row.