[milis-belajar-excel] Rumus sesudah huruf tertentu

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[milis-belajar-excel] Rumus sesudah huruf tertentu

JAKA KAMIRIN
Maaf mau tanya, 
Misal saya punya di Cell sbb :
A1 : 50 x 700 x 6
A2 : 50 x 700 x 7,5

Bagaimana cara mengambil angka terakhir 6 & 7,5 di Cell B1 & B2?
B1 hasilnya 6
B2 hasilnya 7,5

Terima Kasih atas bantuannya



--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bVfK6a1Oyu%3D0Xp-vHcR3N-rmYFwiQYAjknpWzCsbG0ZBg%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Rumus sesudah huruf tertentu

hendrik karnadi
Hai Jaka,

Gunakan Fungis Kombinasi ini pada sel B1
=RIGHT(A1,LEN(A1)-FIND(" ",A1,10))
Untuk sel B2 tinggal dicopy.

Selamat mencoba.

Salam,
HK


On Tuesday, 2 March 2021, 04:49:58 pm GMT+7, JAKA KAMIRIN <[hidden email]> wrote:


Maaf mau tanya, 
Misal saya punya di Cell sbb :
A1 : 50 x 700 x 6
A2 : 50 x 700 x 7,5

Bagaimana cara mengambil angka terakhir 6 & 7,5 di Cell B1 & B2?
B1 hasilnya 6
B2 hasilnya 7,5

Terima Kasih atas bantuannya



--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bVfK6a1Oyu%3D0Xp-vHcR3N-rmYFwiQYAjknpWzCsbG0ZBg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1413672614.2034333.1614691367527%40mail.yahoo.com.
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Rumus sesudah huruf tertentu

JAKA KAMIRIN
Dear Pa Hendrik Karnadi,

Terima Kasih Pak, jawabannya sudah benar, sudah saya praktikkan, hanya saja jika di Cell A1 tsb saya ganti jadi
50 x 1000 x 6 tapi masih beda yaa?
Intinya maksud saya, cara mengambil angka di akhir Cell tsb, setelah tanda "x" yang kedua pada Cell tsb


Terima Kasih

Pada tanggal Sel, 2 Mar 2021 20.22, 'hendrik karnadi' via milis Belajar-Excel <[hidden email]> menulis:
Hai Jaka,

Gunakan Fungis Kombinasi ini pada sel B1
=RIGHT(A1,LEN(A1)-FIND(" ",A1,10))
Untuk sel B2 tinggal dicopy.

Selamat mencoba.

Salam,
HK


On Tuesday, 2 March 2021, 04:49:58 pm GMT+7, JAKA KAMIRIN <[hidden email]> wrote:


Maaf mau tanya, 
Misal saya punya di Cell sbb :
A1 : 50 x 700 x 6
A2 : 50 x 700 x 7,5

Bagaimana cara mengambil angka terakhir 6 & 7,5 di Cell B1 & B2?
B1 hasilnya 6
B2 hasilnya 7,5

Terima Kasih atas bantuannya



--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bVfK6a1Oyu%3D0Xp-vHcR3N-rmYFwiQYAjknpWzCsbG0ZBg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1413672614.2034333.1614691367527%40mail.yahoo.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bUgDckZOLWcj9skTN1TEOoi6bmdk6oZMd%2BEcWdeLtfi2g%40mail.gmail.com.
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Rumus sesudah huruf tertentu

Kid
Administrator
Coba begini :
0
1. ubah semua x dengan banyak sekali spasi (minimal sebanyak karakter yang akan diambil)
    =Substitute( teksnya , "x" , "                  " )     -> bagian "                " bisa diganti juga dengan formula berbunyi Rept( " " , 9 )
2. hasil nomor 1 sudah memisahkan setiap bagian teks dalam blok-blok terpisah spasi yang banyak, maka mulai ambil dari kanan (sesuai kebutuhan) sebanyak jumlah karakter yang dipakai
    =Right( hasil_nomor1 , 9 )    -> misal maksimal karakter yang mungkin terjadi adalah 9 karakter seperti 1234.5678 dan sebagainya
3. buang semua spasi berlebih
    =Trim( hasil_nomor2 )

Kalau digabung, bisa menjadi :
   = Trim(  Right(  Substitute( teksnya , "x"  ,   Rept(  " "   , 9  )  )  , 9 )  )

Jika karakter x terkadang pakai kapital terkadang tidak, maka bagian teksnya diganti dengan Lower( teksnya )
   = Trim(  Right(  Substitute( Lower( teksnya ) , "x"  ,   Rept(  " "   , 9  )  )  , 9 )  )      -> pastikan "x" adalah huruf kecil, karena teksnya sudah di-lower-ken

Regards,
Kid





On Fri, Mar 5, 2021 at 7:46 PM JAKA KAMIRIN <[hidden email]> wrote:
Dear Pa Hendrik Karnadi,

Terima Kasih Pak, jawabannya sudah benar, sudah saya praktikkan, hanya saja jika di Cell A1 tsb saya ganti jadi
50 x 1000 x 6 tapi masih beda yaa?
Intinya maksud saya, cara mengambil angka di akhir Cell tsb, setelah tanda "x" yang kedua pada Cell tsb


Terima Kasih

Pada tanggal Sel, 2 Mar 2021 20.22, 'hendrik karnadi' via milis Belajar-Excel <[hidden email]> menulis:
Hai Jaka,

Gunakan Fungis Kombinasi ini pada sel B1
=RIGHT(A1,LEN(A1)-FIND(" ",A1,10))
Untuk sel B2 tinggal dicopy.

Selamat mencoba.

Salam,
HK


On Tuesday, 2 March 2021, 04:49:58 pm GMT+7, JAKA KAMIRIN <[hidden email]> wrote:


Maaf mau tanya, 
Misal saya punya di Cell sbb :
A1 : 50 x 700 x 6
A2 : 50 x 700 x 7,5

Bagaimana cara mengambil angka terakhir 6 & 7,5 di Cell B1 & B2?
B1 hasilnya 6
B2 hasilnya 7,5

Terima Kasih atas bantuannya



--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bVfK6a1Oyu%3D0Xp-vHcR3N-rmYFwiQYAjknpWzCsbG0ZBg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1413672614.2034333.1614691367527%40mail.yahoo.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bUgDckZOLWcj9skTN1TEOoi6bmdk6oZMd%2BEcWdeLtfi2g%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPuqcnqJH%2B88bsQCdt%3DAhxVnuW%3Doi0QRfVzotsFcLfYU0g%40mail.gmail.com.
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Rumus sesudah huruf tertentu

JAKA KAMIRIN
Dear Pa Kid,

Alhamdulillah sudah bisa sesuai apa yang saya inginkan, baik rumus dengan lower maupun tanpa lower.

Terima Kasih yaa Pak

Salam,
Jaka

Pada tanggal Jum, 5 Mar 2021 19.57, Mr. Kid <[hidden email]> menulis:
Coba begini :
0
1. ubah semua x dengan banyak sekali spasi (minimal sebanyak karakter yang akan diambil)
    =Substitute( teksnya , "x" , "                  " )     -> bagian "                " bisa diganti juga dengan formula berbunyi Rept( " " , 9 )
2. hasil nomor 1 sudah memisahkan setiap bagian teks dalam blok-blok terpisah spasi yang banyak, maka mulai ambil dari kanan (sesuai kebutuhan) sebanyak jumlah karakter yang dipakai
    =Right( hasil_nomor1 , 9 )    -> misal maksimal karakter yang mungkin terjadi adalah 9 karakter seperti 1234.5678 dan sebagainya
3. buang semua spasi berlebih
    =Trim( hasil_nomor2 )

Kalau digabung, bisa menjadi :
   = Trim(  Right(  Substitute( teksnya , "x"  ,   Rept(  " "   , 9  )  )  , 9 )  )

Jika karakter x terkadang pakai kapital terkadang tidak, maka bagian teksnya diganti dengan Lower( teksnya )
   = Trim(  Right(  Substitute( Lower( teksnya ) , "x"  ,   Rept(  " "   , 9  )  )  , 9 )  )      -> pastikan "x" adalah huruf kecil, karena teksnya sudah di-lower-ken

Regards,
Kid





On Fri, Mar 5, 2021 at 7:46 PM JAKA KAMIRIN <[hidden email]> wrote:
Dear Pa Hendrik Karnadi,

Terima Kasih Pak, jawabannya sudah benar, sudah saya praktikkan, hanya saja jika di Cell A1 tsb saya ganti jadi
50 x 1000 x 6 tapi masih beda yaa?
Intinya maksud saya, cara mengambil angka di akhir Cell tsb, setelah tanda "x" yang kedua pada Cell tsb


Terima Kasih

Pada tanggal Sel, 2 Mar 2021 20.22, 'hendrik karnadi' via milis Belajar-Excel <[hidden email]> menulis:
Hai Jaka,

Gunakan Fungis Kombinasi ini pada sel B1
=RIGHT(A1,LEN(A1)-FIND(" ",A1,10))
Untuk sel B2 tinggal dicopy.

Selamat mencoba.

Salam,
HK


On Tuesday, 2 March 2021, 04:49:58 pm GMT+7, JAKA KAMIRIN <[hidden email]> wrote:


Maaf mau tanya, 
Misal saya punya di Cell sbb :
A1 : 50 x 700 x 6
A2 : 50 x 700 x 7,5

Bagaimana cara mengambil angka terakhir 6 & 7,5 di Cell B1 & B2?
B1 hasilnya 6
B2 hasilnya 7,5

Terima Kasih atas bantuannya



--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bVfK6a1Oyu%3D0Xp-vHcR3N-rmYFwiQYAjknpWzCsbG0ZBg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1413672614.2034333.1614691367527%40mail.yahoo.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bUgDckZOLWcj9skTN1TEOoi6bmdk6oZMd%2BEcWdeLtfi2g%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPuqcnqJH%2B88bsQCdt%3DAhxVnuW%3Doi0QRfVzotsFcLfYU0g%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bVQ4xJ8WdmBTON%2BBuqxkHn_-G2LT-LdNvLtW3atohXF%2BA%40mail.gmail.com.
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [milis-belajar-excel] Rumus sesudah huruf tertentu

Kid
Administrator
Alhamdulillah

On Fri, Mar 12, 2021 at 2:52 PM JAKA KAMIRIN <[hidden email]> wrote:
Dear Pa Kid,

Alhamdulillah sudah bisa sesuai apa yang saya inginkan, baik rumus dengan lower maupun tanpa lower.

Terima Kasih yaa Pak

Salam,
Jaka

Pada tanggal Jum, 5 Mar 2021 19.57, Mr. Kid <[hidden email]> menulis:
Coba begini :
0
1. ubah semua x dengan banyak sekali spasi (minimal sebanyak karakter yang akan diambil)
    =Substitute( teksnya , "x" , "                  " )     -> bagian "                " bisa diganti juga dengan formula berbunyi Rept( " " , 9 )
2. hasil nomor 1 sudah memisahkan setiap bagian teks dalam blok-blok terpisah spasi yang banyak, maka mulai ambil dari kanan (sesuai kebutuhan) sebanyak jumlah karakter yang dipakai
    =Right( hasil_nomor1 , 9 )    -> misal maksimal karakter yang mungkin terjadi adalah 9 karakter seperti 1234.5678 dan sebagainya
3. buang semua spasi berlebih
    =Trim( hasil_nomor2 )

Kalau digabung, bisa menjadi :
   = Trim(  Right(  Substitute( teksnya , "x"  ,   Rept(  " "   , 9  )  )  , 9 )  )

Jika karakter x terkadang pakai kapital terkadang tidak, maka bagian teksnya diganti dengan Lower( teksnya )
   = Trim(  Right(  Substitute( Lower( teksnya ) , "x"  ,   Rept(  " "   , 9  )  )  , 9 )  )      -> pastikan "x" adalah huruf kecil, karena teksnya sudah di-lower-ken

Regards,
Kid





On Fri, Mar 5, 2021 at 7:46 PM JAKA KAMIRIN <[hidden email]> wrote:
Dear Pa Hendrik Karnadi,

Terima Kasih Pak, jawabannya sudah benar, sudah saya praktikkan, hanya saja jika di Cell A1 tsb saya ganti jadi
50 x 1000 x 6 tapi masih beda yaa?
Intinya maksud saya, cara mengambil angka di akhir Cell tsb, setelah tanda "x" yang kedua pada Cell tsb


Terima Kasih

Pada tanggal Sel, 2 Mar 2021 20.22, 'hendrik karnadi' via milis Belajar-Excel <[hidden email]> menulis:
Hai Jaka,

Gunakan Fungis Kombinasi ini pada sel B1
=RIGHT(A1,LEN(A1)-FIND(" ",A1,10))
Untuk sel B2 tinggal dicopy.

Selamat mencoba.

Salam,
HK


On Tuesday, 2 March 2021, 04:49:58 pm GMT+7, JAKA KAMIRIN <[hidden email]> wrote:


Maaf mau tanya, 
Misal saya punya di Cell sbb :
A1 : 50 x 700 x 6
A2 : 50 x 700 x 7,5

Bagaimana cara mengambil angka terakhir 6 & 7,5 di Cell B1 & B2?
B1 hasilnya 6
B2 hasilnya 7,5

Terima Kasih atas bantuannya



--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bVfK6a1Oyu%3D0Xp-vHcR3N-rmYFwiQYAjknpWzCsbG0ZBg%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1413672614.2034333.1614691367527%40mail.yahoo.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAP5F6bUgDckZOLWcj9skTN1TEOoi6bmdk6oZMd%2BEcWdeLtfi2g%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPuqcnqJH%2B88bsQCdt%3DAhxVnuW%3Doi0QRfVzotsFcLfYU0g%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPvgvUa1NG5kcYXm%3D9%2BHqmb%3D708%3DSAosEgsfyxNHD3%3DwSQ%40mail.gmail.com.