R
Radenko Zec
How to do in excel ALL CAPS command like in WORD.To make small caps Big?
I found some function upper but i cant do it in same cell?
I found some function upper but i cant do it in same cell?
R
Ron de Bruin
Hi Radenko
Code is the only way in Excel
See this webpages
http://www.mvps.org/dmcritchie/excel/proper.htm
Or
http://www.cpearson.com/excel/case.htm
Here is a macro for changing text cells in the selection
Sub Uppercase_macro()
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selectie Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each cel In selectie
cel.Value = UCase(cel.Value)
Next cel
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
Code is the only way in Excel
See this webpages
http://www.mvps.org/dmcritchie/excel/proper.htm
Or
http://www.cpearson.com/excel/case.htm
Here is a macro for changing text cells in the selection
Sub Uppercase_macro()
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selectie Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each cel In selectie
cel.Value = UCase(cel.Value)
Next cel
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
R
Radenko Zec
Thanks all.
A
aaron.kempf
well if you keep your DATA in a DATABASE it is easy to format it in any
way that you want.
Excel isn't an acceptable tool; only retards and lepers use it for
anything
-Aaron
DBA / Developer
way that you want.
Excel isn't an acceptable tool; only retards and lepers use it for
anything
-Aaron
DBA / Developer
Z
Zilbandy
Why, aren't we in a special mood. Mama forget to put a Twinkie in your
lunch today?
A
aaron.kempf
seriously, fucknut
keep your DATA in one place.. and then you can RENDER it either upper
case or lower case.. without bloating.
in Excel if you want the data in uppercase and lowercase then you have
2 copies of the same data.
It's just ridiculous
in Excel if you want the data SORTED ascending and descending.. then
you have 2 copies of the same data.
it's just ridiculous
anyone using Excel for anything should be FIRED and then SPIT UPON.
you idiots are stuck in the 1st grade of the technology ladder
-Aaron
DBA
keep your DATA in one place.. and then you can RENDER it either upper
case or lower case.. without bloating.
in Excel if you want the data in uppercase and lowercase then you have
2 copies of the same data.
It's just ridiculous
in Excel if you want the data SORTED ascending and descending.. then
you have 2 copies of the same data.
it's just ridiculous
anyone using Excel for anything should be FIRED and then SPIT UPON.
you idiots are stuck in the 1st grade of the technology ladder
-Aaron
DBA
Z
Zilbandy
That's right. That's where I am when it comes to data bases. But,
even you were there at one time, and even you pooped in your diaper at
one time in your life. You may be there technically, but you are still
a titty sucking, diaper pooping baby when it comes to social skills.
Welcome to my kill file.
M
Master Programmer
**** you ya fat hillbilly. I saw your web site, it sucks by the way.
And whats all that "In remembrance of 9/11" rubbish - thats history man
- who cares !
When will you people learn.....
The correct formatting for September 11th is 11/9 NOT 9/11 - you have
it back to front over there. Duhhh
The Grand Master
And whats all that "In remembrance of 9/11" rubbish - thats history man
- who cares !
When will you people learn.....
The correct formatting for September 11th is 11/9 NOT 9/11 - you have
it back to front over there. Duhhh
The Grand Master
A
aaron.kempf
I could give a shit about social skills; brother
I'm 'sa' i dont need social skills lol
I just am sick and tired of people using the wrong program and then
bitching when things are 'oh theyre just so complex'
shit I could upper case shit in a database with my eyes closed.. it's
ridiculous that in Excel you have to deal with all of these duplicated
formulas...
in the database world-- I write this UPPER function ONCE.
how many times do you need to jam your 'format cells' up your ass?
**** excel and anyone that uses it
-Aaron
I'm 'sa' i dont need social skills lol
I just am sick and tired of people using the wrong program and then
bitching when things are 'oh theyre just so complex'
shit I could upper case shit in a database with my eyes closed.. it's
ridiculous that in Excel you have to deal with all of these duplicated
formulas...
in the database world-- I write this UPPER function ONCE.
how many times do you need to jam your 'format cells' up your ass?
**** excel and anyone that uses it
-Aaron
M
Master Programmer
You havnt seen me. I saw a pic of you on your site lard ass.
You just like to do things differently than the rest of the world. That
makes you inferior. Ha, you even voted in an illiterate president
(twice). Go sleep with your cousins or something you redneck.
The Grand Master
A
aaron.kempf
Master;
I love you like a brother for having some balls and standing up to
these fuckers
but I strongly support my president; he has the balls to stand up for
our safety.
under Bill Clinton; America was attacked a HALF DOZEN TIMES AND DIDNT
LIFE A FINGER
the cole bombing; world trade center 1?
need I continue?
I think that we should invite your lil island to join our holy union
but on the other hand; I also think that your little island should be
living under a german flag right now
-Aaron
I love you like a brother for having some balls and standing up to
these fuckers
but I strongly support my president; he has the balls to stand up for
our safety.
under Bill Clinton; America was attacked a HALF DOZEN TIMES AND DIDNT
LIFE A FINGER
the cole bombing; world trade center 1?
need I continue?
I think that we should invite your lil island to join our holy union
but on the other hand; I also think that your little island should be
living under a german flag right now
-Aaron
M
Master Programmer
Dude
If the US of A didn't run around gung-ho trying to hyjack oil under the
guise of spreading the good word of democracy (and religion) - then
they wouldnt be in the mess they are today.
I can't help sniggering when I see watch the famous speech that
chimpanzee made on that aircraft carrier.... "Mission Accomplished" -
yeah right ! Its a laugh to watch a few camel boy rag heads filling a
few body bags, the US deserves it.
Did you see I got another alias?
The Grand Master
Visual Basic Jihad - The GOD of languages
If the US of A didn't run around gung-ho trying to hyjack oil under the
guise of spreading the good word of democracy (and religion) - then
they wouldnt be in the mess they are today.
I can't help sniggering when I see watch the famous speech that
chimpanzee made on that aircraft carrier.... "Mission Accomplished" -
yeah right ! Its a laugh to watch a few camel boy rag heads filling a
few body bags, the US deserves it.
Did you see I got another alias?
The Grand Master
Visual Basic Jihad - The GOD of languages
A
aaron.kempf
listen asswhore
just because Syria and Iran have been assisting the resistance; does
that mean that we haven't done our jobs?
We need to broaden this engagement; and I sure hope that we get a
Republican president in the next election or we're all hosed.
We didn't hijack jack shit under any guises.
Mother fucking Saddam Hussein was paying people to blow themselves up
in the WEST BANK.
Mother fucking Saddam Hussein _WAS_ building WMD; he probably gave them
to Syria or Iran so that we wouldn't find them.
We're not going to appease these fuckers anymore... Do you remember
what happened when Chamberlain bent over and let Hitler take parts of
Czechoslovakia?
Do you remember that?
You britsh pansies almost cost the world a friggin _continent_
-Aaron
just because Syria and Iran have been assisting the resistance; does
that mean that we haven't done our jobs?
We need to broaden this engagement; and I sure hope that we get a
Republican president in the next election or we're all hosed.
We didn't hijack jack shit under any guises.
Mother fucking Saddam Hussein was paying people to blow themselves up
in the WEST BANK.
Mother fucking Saddam Hussein _WAS_ building WMD; he probably gave them
to Syria or Iran so that we wouldn't find them.
We're not going to appease these fuckers anymore... Do you remember
what happened when Chamberlain bent over and let Hitler take parts of
Czechoslovakia?
Do you remember that?
You britsh pansies almost cost the world a friggin _continent_
-Aaron
A
aaron.kempf
dude I like 'vbjihad'
you got .COM yet? or .CO.UK?
we can just flame the crap out of people.. build some tools to automate
posting to usenet.. it could be a lot of fun
I used to spam / spider for a living
I don't see your new alias.. I make a new alias probably once a month--
whenever I get stuck and I _REALLY_ need an answer; I respond to some
of my main questions with one of my new alias; and I usually get help
lol
-Aaron
you got .COM yet? or .CO.UK?
we can just flame the crap out of people.. build some tools to automate
posting to usenet.. it could be a lot of fun
I used to spam / spider for a living
I don't see your new alias.. I make a new alias probably once a month--
whenever I get stuck and I _REALLY_ need an answer; I respond to some
of my main questions with one of my new alias; and I usually get help
lol
-Aaron
M
Master Programmer
just because Syria and Iran have been assisting the resistance; does
Why not just let the rag heads just keep their filthy sandpit.
Great, a few less jews to have to bother with. The should withdraw any
support for Israel, its a country that should not exist.
I think that the media blows things out of preportion, a lot of what we
see on tv is govt propaganda. Saddam bas basically a nice guy.
country.
Steve Ray Irwin
The Grand Master
Yeah right ! And you won the war in Vietnam too - ha ha.
Why not just let the rag heads just keep their filthy sandpit.
Great, a few less jews to have to bother with. The should withdraw any
support for Israel, its a country that should not exist.
I think that the media blows things out of preportion, a lot of what we
see on tv is govt propaganda. Saddam bas basically a nice guy.
I have 3 citizenships, if my country goes too war I just change
country.
Steve Ray Irwin
The Grand Master
M
Master Programmer
No I got (e-mail address removed). I really shafted those stupid fucks from
the VB group. I posted as raj saying I wanted a book on programming
vb. The I came in as master saying vb was to be canned. Then raj
decided against vb and went for java.That fucker that writes books (Tim
I think) got all hot under the collar, ha ha, stupid ****.
You are right, we need tools for automating the flames, or at least for
starting them. If we made say 100 different scripts we could fire them
off 4-5 times a day through all of the MS groups.
The Grand Master
Steve Ray Irwin
the VB group. I posted as raj saying I wanted a book on programming
vb. The I came in as master saying vb was to be canned. Then raj
decided against vb and went for java.That fucker that writes books (Tim
I think) got all hot under the collar, ha ha, stupid ****.
You are right, we need tools for automating the flames, or at least for
starting them. If we made say 100 different scripts we could fire them
off 4-5 times a day through all of the MS groups.
The Grand Master
Steve Ray Irwin
M
Master Programmer
You know that Tim (the book author), well I recon that RobinS is the
same person. He recommended one of Tims books to a newbie the other
day. But I slagged it off (even though I have never read it - ha ha).
The Grand Master
same person. He recommended one of Tims books to a newbie the other
day. But I slagged it off (even though I have never read it - ha ha).
The Grand Master
M
Master Programmer
Aaaron
Keep referring to the next replacement language for VB as D@, I think
it pisses them off. Probably because its too close to reality.
Steve
Keep referring to the next replacement language for VB as D@, I think
it pisses them off. Probably because its too close to reality.
Steve
A
aaron.kempf
steve irwin.. like the alligator guy?
my girlfriend cries about your death like EVERY SINGLE DAY for the past
6 months lol
I hate british people.. I wish I had a couple of stukas right now; I'd
love to run some bombing raids on london
-Aaron
my girlfriend cries about your death like EVERY SINGLE DAY for the past
6 months lol
I hate british people.. I wish I had a couple of stukas right now; I'd
love to run some bombing raids on london
-Aaron
J
jlepack
Steve Irwin was Australian...
Cheers!
Cheers!