Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
ask me and i'll answer all the questions about ms office..Dito tayo mga excel masters. lapag lang kayo ng question regarding excel. Tulong-tulong lang tayo mga lodi.
Post lang ako dito ng mga tutorials and simple excel tricks.
you mean coding?Hello mga master
possible po ba maging automatic ung pagtatransfer ng selected data from notepad to excel?
meron po ba sa inyo me alam? malaking tulong sakin sa work.
thank you
Moderator Note:
Merged with similar threads.
there is excel features there called Sorting...but you need to execute not automatic..automatic means you have to do coding..sir please see below example.
ung selected data sa notepad po i automatic transfer sa excel na naka sunud sunud.
thank u sir
View attachment 8791View attachment 8792View attachment 8793
'\W0.9000;ROOM_NAME
'\W0.9000;
hindi ako masyado nagamit ng excel
question : eto ang content ng cell
Code:'\W0.9000;ROOM_NAME
paano ko aalisin ang
Code:'\W0.9000;
just a background bakit may ganun?
data extracted yan from an autocad attribute.
yung '\W0.9000; is mtext formatting
@themonyo baka alam mo to? magaling ka excel alam ko
=LEFT(A1, FIND(";",A1)-1)
=RIGHT(A1, FIND(";",A1))
ganito naging result.. or may mali akong nagawa?
heto... mahaba... up to a 999,999,999 ang supported with cent and pesos sa dulo... supposedly decimal yun... tanggalin mo na lang pag di mo kelanganTanong po mga lods, may formula kaya na yung amount in numbers ay maconvert sa amount in words?
salamat..
=CHOOSE(LEFT(TEXT(B19,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
&IF(--LEFT(TEXT(B19,"000000000.00"))=0,,IF(AND(--MID(TEXT(B19,"000000000.00"),2,1)=0,--MID(TEXT(B19,"000000000.00"),3,1)=0)," Hundred"," Hundred and "))
&CHOOSE(MID(TEXT(B19,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
&IF(--MID(TEXT(B19,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(B19,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),
CHOOSE(MID(TEXT(B19,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))
&IF((--LEFT(TEXT(B19,"000000000.00"))+MID(TEXT(B19,"000000000.00"),2,1)+MID(TEXT(B19,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(B19,"000000000.00"),4,1)+MID(TEXT(B19,"000000000.00"),5,1)+MID(TEXT(B19,"000000000.00"),6,1)+MID(TEXT(B19,"000000000.00"),7,1))=0,(--MID(TEXT(B19,"000000000.00"),8,1)+RIGHT(TEXT(B19,"000000000.00")))>0)," Million and "," Million "))
&CHOOSE(MID(TEXT(B19,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
&IF(--MID(TEXT(B19,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(B19,"000000000.00"),5,1)=0,--MID(TEXT(B19,"000000000.00"),6,1)=0)," Hundred"," Hundred and"))
&CHOOSE(MID(TEXT(B19,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety")
&IF(--MID(TEXT(B19,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(B19,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(B19,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen"))
&IF((--MID(TEXT(B19,"000000000.00"),4,1)+MID(TEXT(B19,"000000000.00"),5,1)+MID(TEXT(B19,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(B19,"000000000.00"),7,1)+MID(TEXT(B19,"000000000.00"),8,1)+MID(TEXT(B19,"000000000.00"),9,1))=0,--MID(TEXT(B19,"000000000.00"),7,1)<>0)," Thousand "," Thousand and "))
&CHOOSE(MID(TEXT(B19,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine")
&IF(--MID(TEXT(B19,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(B19,"000000000.00"),8,1)=0,--MID(TEXT(B19,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))&
CHOOSE(MID(TEXT(B19,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ")
&IF(--MID(TEXT(B19,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(B19,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(B19,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))
&" Pesos & "&RIGHT(TEXT(B19,"000000000.00"),2)&"/100"
Grabe ang haba salamat lods, ita-try ko agad..@c_i_a_o
sorry, di ko na alam... siguro gagawan ng macro na ichecheck ang file list or files with current date? pero di ako marunong gumawa ng macro
heto... mahaba... up to a 999,999,999 ang supported with cent and pesos sa dulo... supposedly decimal yun... tanggalin mo na lang pag di mo kelangan
yung cell B19 ang location ng value
=CHOOSE(LEFT(TEXT(B19,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--LEFT(TEXT(B19,"000000000.00"))=0,,IF(AND(--MID(TEXT(B19,"000000000.00"),2,1)=0,--MID(TEXT(B19,"000000000.00"),3,1)=0)," Hundred"," Hundred and ")) &CHOOSE(MID(TEXT(B19,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(B19,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(B19,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"), CHOOSE(MID(TEXT(B19,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &IF((--LEFT(TEXT(B19,"000000000.00"))+MID(TEXT(B19,"000000000.00"),2,1)+MID(TEXT(B19,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(B19,"000000000.00"),4,1)+MID(TEXT(B19,"000000000.00"),5,1)+MID(TEXT(B19,"000000000.00"),6,1)+MID(TEXT(B19,"000000000.00"),7,1))=0,(--MID(TEXT(B19,"000000000.00"),8,1)+RIGHT(TEXT(B19,"000000000.00")))>0)," Million and "," Million ")) &CHOOSE(MID(TEXT(B19,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(B19,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(B19,"000000000.00"),5,1)=0,--MID(TEXT(B19,"000000000.00"),6,1)=0)," Hundred"," Hundred and")) &CHOOSE(MID(TEXT(B19,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety") &IF(--MID(TEXT(B19,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(B19,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(B19,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen")) &IF((--MID(TEXT(B19,"000000000.00"),4,1)+MID(TEXT(B19,"000000000.00"),5,1)+MID(TEXT(B19,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(B19,"000000000.00"),7,1)+MID(TEXT(B19,"000000000.00"),8,1)+MID(TEXT(B19,"000000000.00"),9,1))=0,--MID(TEXT(B19,"000000000.00"),7,1)<>0)," Thousand "," Thousand and ")) &CHOOSE(MID(TEXT(B19,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(B19,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(B19,"000000000.00"),8,1)=0,--MID(TEXT(B19,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))& CHOOSE(MID(TEXT(B19,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(B19,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(B19,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(B19,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &" Pesos & "&RIGHT(TEXT(B19,"000000000.00"),2)&"/100"