MACAM-MACAM FUNGSI TEKS :

1. FUNGSI LEFT
   
   DIGUNAKAN UNTUK MENGAMBIL BEBERAPA KARAKTER DARI KIRI PADA SEBUAH STRING TEKS YANG DIPILIH.
   
   FORMAT PENULISANNYA ; =LEFT(TEXT;NUM_CHARS)
2. FUNGSI RIGHT
   
   DIGUNAKAN UNTUK MENGAMBIL BEBERAPA KARAKTER DARI KANAN PADA SEBUAH STRING TEKS YANG DIPILIH.
   
   FORMAT PENULISANNYA ; =RIGHT( TEXT;NUM_CHARS )
   
   
3. FUNGSI MID
   DIGUNAKAN UNTUK MENGAMBIL BEBERAPA KARAKTER DENGAN MENENTUKAN TERLEBIH DAHULU POSISI AWAL KARAKTER DAN BEBERAPA KARAKTER PADA TEKS YANG AKAN DI MUNCULKAN.
   
   FORMAT PENULISANNYA ; =MID(TEXT;START_NUM;NUM_CHARS)
4. FUNGSI VALUE
   DIGUNAKAN UNTUK MENGUBAHTIPE DATA ALFA NUMERIKMENJADI NUMERIK.
   
   FORMAT PENULISANNYA ; =VALUE(MID(NUM_CHARS))
   
   TIPE DATA / JENIS DATA DI DALAM EXEL ADA DUA ;
   -NUMERIK             : ANGKA YANG DITULIS LANGSUNG
   -ALFA NUMERIK  : TIDAK BISA DI UBAH MENJADI NILAI (RP)
   A. ABJAD
   B. GABUNGAN ABJAD DAN ANGKA

fall for you

The best thing about tonight's that we're not fighting
Could it be that we have been this way before
I know you don't think that I am trying
I know you're wearing thin down to the core

But hold your breathe
Because tonight will be the night
That I will fall for you
Over again
Don't make me change my mind
Or I won't live to see another day
I swear it's true
Because a girl like you is impossible to find
You're impossible to find

This is not what I intended
I always swore to you I'd never fall apart
You always thought that I was stronger
I may have failed but I have loved you from the start

Oh, But hold your breathe
Because tonight will be the night
That I will fall for you
Over again
Don't make me change my mind
Or I won't live to see another day
I swear it's true
Because a girl like you is impossible to find
It's impossible
So breathe in so deep
Breathe me in
I'm yours to keep
And hold on to your words
Cause talk is cheap
And remember me tonight
When you're asleep

Because tonight will be the night
That I will fall for you
Over again
Don't make me change my mind
Or I won't live to see another day
I swear it's true
Because a girl like you is impossible to find

Tonight will be the night
That I will fall for you
Over again
Don't make me change my mind
Or I won't live to see another day
I swear it's true
Because a girl like you is impossible to find
You're impossible to find

one thing, one direction