Symbianize Forum
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!
MS EXCEL TUTORIALS AND QUERIES
- Thread starter Babes0601
- Start date
- Replies 74
- Views 4,793
- Messages
- 5,608
- Reaction score
- 187
- Points
- 308
ayun, meron na pala. gawa sana ako 
pa-subscribe dito.
active member din dun ako sa original thread
pa-subscribe dito.
active member din dun ako sa original thread
true power of MS excel. update: PowerBI
- Messages
- 193
- Reaction score
- 210
- Points
- 28
ask me and i'll answer all the questions about ms office..
- Messages
- 34
- Reaction score
- 1
- Points
- 28
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.
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.
Last edited by a moderator:
- Messages
- 5,608
- Reaction score
- 187
- Points
- 308
may thread na tayo ng excel at may mga expert tutulong dun.
baka may macro/script sila para sa gusto mo mangyari.
mas maganda makapag-provide ka ng sample ng data from clipboard at target table
baka may macro/script sila para sa gusto mo mangyari.
mas maganda makapag-provide ka ng sample ng data from clipboard at target table
MS EXCEL TUTORIALS AND QUERIES
- Messages
- 193
- Reaction score
- 210
- Points
- 28
you mean coding?
Post automatically merged:
there is excel features there called Sorting...but you need to execute not automatic..automatic means you have to do coding..
- Messages
- 9,699
- Reaction score
- 5,000
- Points
- 913
hindi ako masyado nagamit ng excel
question : eto ang content ng cell
paano ko aalisin ang
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 
question : eto ang content ng cell
Code:
'\W0.9000;ROOM_NAMEpaano 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 
- Messages
- 5,238
- Reaction score
- 2,152
- Points
- 1,538
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?
Code:
=LEFT(A1, FIND(";",A1)-1)
Code:
=RIGHT(A1, FIND(";",A1))
ganito po sir?
- Messages
- 9,699
- Reaction score
- 5,000
- Points
- 913
- Messages
- 5,238
- Reaction score
- 2,152
- Points
- 1,538
ok naman sir yung logic ata ng formula ang mali isang sample lang kasi yung sinubukan ko hehehe
- Messages
- 5,238
- Reaction score
- 2,152
- Points
- 1,538
eto sir sure nayup ni try ko na yan kanina nung ni google ko
may mali siguro sa ginawa ko
Code:
=RIGHT(A1,LEN(A1)-FIND(";",A1))
edit: kailangan hanapin yung length ng data. yun lang po kulang.
Last edited:
- Messages
- 5,608
- Reaction score
- 187
- Points
- 308
nasagot na
yan din formula na gamit ko.
sa office365 may textsplit/split na function na with delimiter support.
supposedly meron din button na text to column pero di ko alam kung anong version nagkaroon. meron sa 2022 pero di ko nagagamit.
pwede mo rin gawin sa google sheets, may split na function yun at madali mag-separate ng text with delimiters <--- heto best choice ko kung marami pero i have to paste back the data to excel.
@c_i_a_o
kung may text file na, pwede mo naman import na instead na open, tapos copy-paste pa. punta ka sa Data tab ng excel tapos click mo yang "From Text/CSV"
kung meron kang msoffice 2022 na regularly updated, may formula na sort()
hiwalay pa yan sa sort and filter na feature.
yan din formula na gamit ko.
sa office365 may textsplit/split na function na with delimiter support.
supposedly meron din button na text to column pero di ko alam kung anong version nagkaroon. meron sa 2022 pero di ko nagagamit.
pwede mo rin gawin sa google sheets, may split na function yun at madali mag-separate ng text with delimiters <--- heto best choice ko kung marami pero i have to paste back the data to excel.
@c_i_a_o
kung may text file na, pwede mo naman import na instead na open, tapos copy-paste pa. punta ka sa Data tab ng excel tapos click mo yang "From Text/CSV"
kung meron kang msoffice 2022 na regularly updated, may formula na sort()
hiwalay pa yan sa sort and filter na feature.
- Messages
- 18
- Reaction score
- 5
- Points
- 18
Tanong po mga lods, may formula kaya na yung amount in numbers ay maconvert sa amount in words?
salamat..
salamat..
- Messages
- 5,608
- Reaction score
- 187
- Points
- 308
@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
yung cell B19 ang location ng value
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"
- Messages
- 18
- Reaction score
- 5
- Points
- 18
Grabe ang haba@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"
salamat lods, ita-try ko agad..
