Coba saja dikalikan 1 diujung belakang. Should work J

 

From: [email protected] [mailto:[email protected]] On 
Behalf Of Emi
Sent: Wednesday, August 08, 2012 7:43 PM
To: [email protected]
Subject: Re: [belajar-excel] Pisahkan data tanpa kolum bantu

 






Dear Wiranata,

 

Terima kasih atas bantuan anda, tetapi hasilnya data di kolum GL tidak menjadi 
rata kiri,tetapi rata tengah dan kanan bisa,

 mungkin karena tidak ada TRIM dalam rumusnya

 

-Emi Lestari

 

 

 

Solusi WIRAnata Kemala Deng         

 

31        5310000001

31        5310000003

31        5310000027

31        5310000156

31        5310000161

40 

               273602

40           273616

40           273622

40           521112

50           650101

40           273602

40           273616

40           273622

40           521112

40           650101

40           696504

50           273622

50           542311

50           620102

50           650101

 

 

  _____  

From: WIRAnata Kemala Deng <[email protected]>
To: [email protected] 
Sent: Wednesday, August 8, 2012 6:00 PM
Subject: Re: [belajar-excel] Pisahkan data tanpa kolum bantu





  

Coba bantu yah, maaf kalo kurang bagus formula nya, masih belajar :)

Posting key
=IFERROR(IF(FIND(" ",B2,1),LEFT(B2,FIND(" ",B2,1)),0),LEFT(B2,2))

GL
=IFERROR(IF(FIND(" ",B2,1),MID(B2, FIND(" ",B2,1),256)),MID(B2,3,256))

sent from my ICS GT-N7000 Note Phablet

On Aug 8, 2012 10:49 AM, "Emi" <[email protected]> wrote:

 

 

Dear para suhu,

Gimana caranya memisah data ke dua kolumn tanpa perlu kolum bantu.

Terima kasih

 emi lestari 

 


Data asli

        Kolum bantu

        posting key 

GL


315310000001

        5310000001

        31

5310000001


315310000003

        5310000003

        31

5310000003


315310000027

        5310000027

        31

5310000027


315310000156

        5310000156

        31

5310000156


315310000161

        5310000161

        31

5310000161


40    273602

            273602

        40

273602


40    273616

            273616

        40

273616


40    273622

            273622

        40

273622


40    521112

            521112

        40

521112


50    650101

            650101

        50

650101


40    273602

            273602

        40

273602


40    273616

            273616

        40

273616


40    273622

            273622

        40

273622


40    521112

            521112

        40

521112


40    650101

            650101

        40

650101


40    696504

            696504

        40

696504


50    273622

            273622

        50

273622


50    542311

            542311

        50

542311


50    620102

            620102

        50

620102


50    650101

            650101

        50

650101

 

 








Kirim email ke