*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
 {  Sila lawat Laman Hizbi-Net -  http://www.hizbi.net     }
 {        Hantarkan mesej anda ke:  [EMAIL PROTECTED]         }
 {        Iklan barangan? Hantarkan ke [EMAIL PROTECTED]     }
 *~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~*
          PAS : KE ARAH PEMERINTAHAN ISLAM YANG ADIL
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Thanks a million to all the consultants out there. Surprisingly the 
response came at 'speed of thought"!! I did give it a try. It works
perfectly. Thanks again!

wassalam,

-----Original Message-----
From: Jalal bin Busri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 9:05 AM
To: AHMAD JAEZAN HJ RAMLI
Cc: [EMAIL PROTECTED]
Subject: Re: H-Net* Excel help needed


Converts text to uppercase.

Syntax

UPPER(text)

Text   is the text you want converted to uppercase. Text can be a reference
or
text string.

Examples

UPPER("total") equals "TOTAL"

If E5 contains "yield", then:

UPPER(E5) equals "YIELD"




 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 ( Melanggan ? To : [EMAIL PROTECTED]   pada body : SUBSCRIBE HIZB)
 ( Berhenti ? To : [EMAIL PROTECTED]  pada body:  UNSUBSCRIBE HIZB)
 ( Segala pendapat yang dikemukakan tidak menggambarkan             )
 ( pandangan rasmi & bukan tanggungjawab HIZBI-Net                  )
 ( Bermasalah? Sila hubungi [EMAIL PROTECTED]                    )
 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Pengirim: AHMAD JAEZAN HJ RAMLI <[EMAIL PROTECTED]>

Kirim email ke