HOME
HOME

Questions
About
Excel Programming

...
...
...

_____________________2010-02-09 12:28:51

   ɷ ??..-->>              [ɷ]

UNO's WORKS()
  • ܼ ̳ ǥ ° ƴ
  • İ İ 踦 Ͽ ǥ 踦 ϰ
  • Ϻ ϰ(Ͽ ϰ)
  • Ǻμ Ӱ ϰ,ȿ˻縦 Ӱ ϰ
  • ⺻ Լ Ȱϰ ϰ
  • ˾ƾ íƮ 쿡 ǥ Ӱ ϰ
  • 迭 ˰Եǰ(˾ƾ ϰ)
  • Ϻ Ͽ Ʈ Ȱϰ
  • ݺ۾ ƴ â ۾ Ȱϰ
  • ηִ ˰
  • ṵ̈ ߿ ܼ ȯų ˰
  • VB ʴ ѵ ִ ڵȭ ھϰ Ͽ
  • ܼ ȸ뽺Ʈ ƴ 濵μ Ȱ
  • Ŀø ǥ̴



[Ŀø ...]
Ʒ å ޾Ҿ ̶ ǵǾϴ..׷..
Cover1,4.jpg (378242 bytes)
ο ߾ ο ļ Ͽ,å̶ Ͽ,¶λ VB Ͽ
UNO-EXCEL-PROGRAMMING
On-Line-Book 籸 ϰ ֽϴ
ۼϰ ÷ Ͽ å ϴ
ǵ å ãô е ̰ ̿Ͻø ɰԴϴ
UNO-EXCEL-PROGRAMMING
VB ʴ ¿ Ȱ Ѱμ å ǥ ġ ϴٰ Ͽ..׷ ׸ ϰ ϱ ϸ鼭 ¶λ Ŀø Ѵ..ǵ å ãô е ̰ ̿Ͻø å ϰ ȴ
EXCEL POWER SERIES

[Business Strategic Tool EXCEL]
  • α׷ֿ ...
  • Ʈ¥ ҷ
  • չ ҷ
  • µ ʿ ҷ
  • +\ ǽǰ ռҷ缱
  • Ÿ ȭý۰
  • ۾ 꼺 ȿ ̽ʽÿ!
  • ȭ̳ ø 帮ڽϴ!!



 


˻ܺεŸ ȭ/NorthWind.mdb
ȸ εǴ ȭ
StudioƮ VB ڵȭ Ѱ ٷ..
ExcelƮ Ϲ ַ ٷ, ׻ ʵ Ѵ


VB ô/600ȸ---------- 2009-04-27
迭 JOIN,SPLITԼ
/VBA̵ ׸ ٲ Ҽ ִ°??INDIRECTԼ Ŀ ̸
[MORE...]
,ݰ, ƴ ؿ ʺ  100 ȭ..


  

̺  Ȱϱ ȭ..20..


 

EXCEL STORY 052

How to count visible characters
̴ ڸ  ˰ ʹ

  • LEN()
  • SUBSTITUTE()

ʺ  Ͽ Լϳ
 Ͽ ?Ѵ
׷ ̷ ϰ ȴ

=len()δ " "κб ջϿ ɴϴ.
" " ڼ
ִ ˷ ּ.
vba å 113 len()ε
Ͽ ڸ ˷ݴϴ

Լ ɵ
Ȳ ôô ° ʴ´
Ͽ ϴ ̴
ʴ ״ ˾Ƽ Ͽ
!!!
׷̴

 ȭ  ʴ´
⺻ ̷ ϼ
׸ Ͽ ǥ غ

׷ ̴
׷ Ͽ ȰǴ ̴
󸶳 Ͽ dz ϸ ,âǷ¸ŭ Ȱȴ

׷
Len ־ ڿ  ڷ ̷
Ǵش
⸦ ϸ ⸦ ͵ ϳ
ڷ ..(ƴ ǻ) ϰ óѴ
ڵ ΰ̴

׷
׷ ڸ ǰڳ??!! Ǿ Ѵ
ڸ ִ Լ ֳ??
!!
ڸ ִ Լ ̰͵ ϸ ȴ
 ڸ ٸ ڷ ٲ!! Լ ִ ̴
SUBSTITUTE()
׳ ܾ ״̴
ٲ!!
׷
=SUBSTITUTE("־ "," ","")
ϸ (" ") ䷸ ("")ٲٶ Ҹ Ǵ
=SUBSTITUTE("־ "," ","")
="־"
Ǵ ̰ ̰ LENԼ ָ ϴ
̴ ڸ īƮϰ ǰ..
=LEN(SUBSTITUTE("־ "," ",""))
ϸ ̴ Ǵ ̴

׷ ְ
̸ ׳ ܵ Ǫ Ͱ ְ
ġ ̴

̴
󸶳 ϴĴ ʰ 󸶳 ưưѰ̳Ŀ
ȴ
Ѱ ָ ϴ ִ ϸ..
Ѱ ָ ׳ Ѱθ ϱ⵵ ϰ
 Ѱ ü ȭŰ⵵ Ѵ

 ࿡ ɸ
Ǯָ ܴ
̴
Ȥ ϴµ
װ ȵȴٰ Ű??
(Contraint,putting obstruction,limiting their ability)
ɰ ð âǷ ϴ
Ǹ ϰ ̴
׳ Ƶθ Ƹ ߳
̴..
!!!


[MORE...]

\˻
εǴ \ȭ

Access-Developer /139ȸ------------- 2008-01-06
     DB_01_̺ Ͽ

[MORE...]

EXCEL POWER SERIES..     ʺ+Ŀ+Programming without VBA

 UNO's WEBLOG...---


ũ ũ̾Ʈ 450ȸ

"Right. Well, he's in St. Louis attending a conference,
"¾ƿ..Ʈ ۷ ϰ ,
and he asked about the Boyette case and Jerome Clifford
and the kid.
׸ Ƽǰ ũƮ(ȣ)
Ͽ
I told him what we knew.
ƴ´ ̾߱ ־ϴ
He said feel free to call if he could do anything.
ڱⰡ Ҽ Ǹ ϰ
ȭ ϶ ϴ
Said Mr. Voyles wants daily reports."
Voyles Ϻ Ѵٰ ϱ"
"I know all this."
" ˾"
"Right. Well, I was just thinking.
"׸ εԴϴ..,
St. Louis is an hour's flight from Memphis, right.
Ʈ ǽ ѽð̸ ưϱ,
What if Mr. Lewis presented himself to the juvenile Court
judge in Memphis first thing in the morning
when the petition is filed,
츮 û Ҷ,
ħ ڸ  ûҳǻտ
ϸ ,
and what if Mr. Lewis has
a little chat with the judge and leans on him?
׸  ǻ ̾߱⸦ ϸ鼭 ¦ ٰ ϸ
?
We're talking about the number-two man in the FBI.
FBI ѹ2 ̴ϱ,
He tells the judge what we think this kid knows"
״ 츮 ༮ ˰ ִ°Ϳ
ǻ翡 Ҽ Ͱƿ"


𿡼 Ǯ
FBI ѹ2  Ȱұ..̾߱ Ѵ
ΰ谡 ƾ Ǯ!! ϴ
Ʈ ö̱⵵ ϴ

Ͼħ ̰ͺ ؾ!!
Ѵٸ Ȳϰ ش Ұ̴
ܾ ϳ ִ
"This is first thing in the morning!!"
first thing!!
óؾ ̴
̾߱⿡ ° ƴϰ..ϻ󿡼 ÷
ϴ ̴
What is your first thing in your life??!!
ʴ λ ߿ϴ??.. Ҽ ְ..
츮 ϰ ϴ ܾ Chattingä
You are too chatty to be together
ʴ ʹ ٰ ؼ ϰڴ!!
׷ϱ Ʒ
a little chat with the judge and leans on him
ǻ 㵵 ϰ ٵ ׸
׿ ½ ..(Leans on him)
ܷοﶧ ϴ 뷡 ִ
Lean On Me

What If ~~
׻ ϴ ̰..
What if you lose your job??!!
 ҷ??!!
What if you fail the examination??
迡  ҷ??!!


[More...]
3474843--

UNO21.COM   Designed and Maintained By  UNO  ()..since 1999/03/24