eh kebalik
=substitute( address( 1, column() ),1,"")

2014/1/25 Mr. Kid <[email protected]>

> oh mau pakai formula untuk dapatkan kolom Excel ya,
>
> Kira-kira begini :
> =substitute( address( row(), 1 ),1,"")
> *** akan terasa manfaatnya kalau sudah sampai kolom AA atau AAA
>
> Wassalam,
> Kid.
>
>
>
> On Sat, Jan 25, 2014 at 9:10 AM, Bagus <[email protected]> wrote:
>
>>
>>
>>  Coba begini:
>>
>> =MID(ADDRESS(ROW(),COLUMN()),2,1)
>>
>>
>>
>> Wassalam
>>
>> ~ Bagus ~
>>
>>
>>
>> ----- Original Message -----
>> *From:* Hirmanto <[email protected]>
>> *To:* [email protected]
>> *Sent:* Saturday, January 25, 2014 8:25 AM
>> *Subject:* [belajar-excel] Mencari Huruf Header Kolom
>>
>>
>>
>>  
>>
>
>

Kirim email ke