dear bos kid..
sudah sering saya melihat gabungan formula yang bos kid berikan ini, tapi
samapai sekarang saya belum bisa mengerti maksud dari gabungan formula ini
sehingga mendapatkan hasil yang di inginkan...bila bos kid ada waktu, tolong di
jabarkan maksud dari formulanya, dan bila memang sudah pernah di jabarkan
tolong infokan link nya terimakasih. :) br,
odong nando
Dari: "'Mr. Kid' [email protected] [belajar-excel]"
<[email protected]>
Kepada: BeExcel <[email protected]>
Dikirim: Senin, 28 November 2016 10:42
Judul: Re: [belajar-excel] Ambil Qty
Hai DD,
Bagian yang akan diambil adalah field ke-3 dari kanan dan bertipe numerik. Dua
buah field terkanan juga bertipe numerik. Delimiter adalah spasi (kecuali pada
field nama produk). Formula :
=IFError( 1 * Trim( Left( Right( Substitute( datanya , " " , Rept( " " , 99 ) )
, 3 * 99 ) , 99 ) ) , "" )
Regards,
Kid
2016-11-28 8:43 GMT+07:00 'Dede Sulaeman' [email protected]
[belajar-excel] <[email protected]>:
Dear Mr Heri, Formulanya belum tepat setelah saya masukan ke kasus
sebenarnya.Untuk karakter #### itu adalah nama produk yang sengaja sayaganti
menjadi ####.File terlampir saya rubah karakter #### menjadi nama
produksembarang. Salam,DD From:
[email protected][mailto:belajar-excel@ yahoogroups.com]
Sent: 26 November 2016 5:14
To: [email protected]
Subject: Re: [belajar-excel] Ambil Qty
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُSemangat pagi,. Pakai angka
coba2 boleh kah ?! =TRIM(LEFT(TRIM(MID(A1;FIND(" ";A1;25);50));FIND("
";TRIM(MID(A1;FIND(" ";A1;25);50));1))) وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ
اللهِ وَبَرَكَاتُهُ Warm Regards,On 25/11/2016 15:26, 'Dede Sulaeman'
dede_sulaeman@pinusmerahabadi. co.id[belajar-excel] wrote:
DearB’Exceler, Sayaada kausus untuk mengambil qty di tengah text, sudah saya
dapatkan angkanyahanya saja apakah ada formula yang lebih simpel dari formula
yang sudah sayabuat? Karena saya perlu banyak membutuhkan kolom bantu untuk
mengambil angkatersebut. Mohon masukannya. Terima kasih. Salam,DD
#yiv7446646069 #yiv7446646069 -- #yiv7446646069ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7446646069
#yiv7446646069ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7446646069
#yiv7446646069ygrp-mkp #yiv7446646069hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7446646069 #yiv7446646069ygrp-mkp #yiv7446646069ads
{margin-bottom:10px;}#yiv7446646069 #yiv7446646069ygrp-mkp .yiv7446646069ad
{padding:0 0;}#yiv7446646069 #yiv7446646069ygrp-mkp .yiv7446646069ad p
{margin:0;}#yiv7446646069 #yiv7446646069ygrp-mkp .yiv7446646069ad a
{color:#0000ff;text-decoration:none;}#yiv7446646069 #yiv7446646069ygrp-sponsor
#yiv7446646069ygrp-lc {font-family:Arial;}#yiv7446646069
#yiv7446646069ygrp-sponsor #yiv7446646069ygrp-lc #yiv7446646069hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7446646069
#yiv7446646069ygrp-sponsor #yiv7446646069ygrp-lc .yiv7446646069ad
{margin-bottom:10px;padding:0 0;}#yiv7446646069 #yiv7446646069actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7446646069
#yiv7446646069activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7446646069
#yiv7446646069activity span {font-weight:700;}#yiv7446646069
#yiv7446646069activity span:first-child
{text-transform:uppercase;}#yiv7446646069 #yiv7446646069activity span a
{color:#5085b6;text-decoration:none;}#yiv7446646069 #yiv7446646069activity span
span {color:#ff7900;}#yiv7446646069 #yiv7446646069activity span
.yiv7446646069underline {text-decoration:underline;}#yiv7446646069
.yiv7446646069attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7446646069 .yiv7446646069attach div a
{text-decoration:none;}#yiv7446646069 .yiv7446646069attach img
{border:none;padding-right:5px;}#yiv7446646069 .yiv7446646069attach label
{display:block;margin-bottom:5px;}#yiv7446646069 .yiv7446646069attach label a
{text-decoration:none;}#yiv7446646069 blockquote {margin:0 0 0
4px;}#yiv7446646069 .yiv7446646069bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7446646069
.yiv7446646069bold a {text-decoration:none;}#yiv7446646069 dd.yiv7446646069last
p a {font-family:Verdana;font-weight:700;}#yiv7446646069 dd.yiv7446646069last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7446646069
dd.yiv7446646069last p span.yiv7446646069yshortcuts
{margin-right:0;}#yiv7446646069 div.yiv7446646069attach-table div div a
{text-decoration:none;}#yiv7446646069 div.yiv7446646069attach-table
{width:400px;}#yiv7446646069 div.yiv7446646069file-title a, #yiv7446646069
div.yiv7446646069file-title a:active, #yiv7446646069
div.yiv7446646069file-title a:hover, #yiv7446646069 div.yiv7446646069file-title
a:visited {text-decoration:none;}#yiv7446646069 div.yiv7446646069photo-title a,
#yiv7446646069 div.yiv7446646069photo-title a:active, #yiv7446646069
div.yiv7446646069photo-title a:hover, #yiv7446646069
div.yiv7446646069photo-title a:visited {text-decoration:none;}#yiv7446646069
div#yiv7446646069ygrp-mlmsg #yiv7446646069ygrp-msg p a
span.yiv7446646069yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7446646069
.yiv7446646069green {color:#628c2a;}#yiv7446646069 .yiv7446646069MsoNormal
{margin:0 0 0 0;}#yiv7446646069 o {font-size:0;}#yiv7446646069
#yiv7446646069photos div {float:left;width:72px;}#yiv7446646069
#yiv7446646069photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7446646069
#yiv7446646069photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7446646069
#yiv7446646069reco-category {font-size:77%;}#yiv7446646069
#yiv7446646069reco-desc {font-size:77%;}#yiv7446646069 .yiv7446646069replbq
{margin:4px;}#yiv7446646069 #yiv7446646069ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7446646069 #yiv7446646069ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7446646069
#yiv7446646069ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7446646069
#yiv7446646069ygrp-mlmsg select, #yiv7446646069 input, #yiv7446646069 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7446646069
#yiv7446646069ygrp-mlmsg pre, #yiv7446646069 code {font:115%
monospace;}#yiv7446646069 #yiv7446646069ygrp-mlmsg *
{line-height:1.22em;}#yiv7446646069 #yiv7446646069ygrp-mlmsg #yiv7446646069logo
{padding-bottom:10px;}#yiv7446646069 #yiv7446646069ygrp-msg p a
{font-family:Verdana;}#yiv7446646069 #yiv7446646069ygrp-msg
p#yiv7446646069attach-count span {color:#1E66AE;font-weight:700;}#yiv7446646069
#yiv7446646069ygrp-reco #yiv7446646069reco-head
{color:#ff7900;font-weight:700;}#yiv7446646069 #yiv7446646069ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7446646069 #yiv7446646069ygrp-sponsor
#yiv7446646069ov li a {font-size:130%;text-decoration:none;}#yiv7446646069
#yiv7446646069ygrp-sponsor #yiv7446646069ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7446646069
#yiv7446646069ygrp-sponsor #yiv7446646069ov ul {margin:0;padding:0 0 0
8px;}#yiv7446646069 #yiv7446646069ygrp-text
{font-family:Georgia;}#yiv7446646069 #yiv7446646069ygrp-text p {margin:0 0 1em
0;}#yiv7446646069 #yiv7446646069ygrp-text tt {font-size:120%;}#yiv7446646069
#yiv7446646069ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7446646069
