All CAPS

[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?

[Ron de Bruin]

Hi Radenko

> I found some function upper but i cant do it in same cell?

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Radenko Zec" <logic_...@hotmail.com> wrote in message news:OveEgVJE...@TK2MSFTNGP02.phx.gbl...

[Mark Ivey]

I found an excellent addin for doing what you want to do...

Go to:  http://www.realezsites.com/bus/primitivesoftware/products.php
and look for a utliity called XL Extras. It gives you a menu item in your Format menu that allows you to change text as needed (plus many more useful workbook functions as well.

"Radenko Zec" <logic_...@hotmail.com> wrote in message news:OveEgVJE...@TK2MSFTNGP02.phx.gbl...

[Radenko Zec]

Thanks all.

"Radenko Zec" <logic_...@hotmail.com> wrote in message
news:OveEgVJE...@TK2MSFTNGP02.phx.gbl...

[aaron...@gmail.com]

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

[Zilbandy]

On 27 Nov 2006 13:15:42 -0800, "aaron...@gmail.com"
<aaron...@gmail.com> wrote:

>Excel isn't an acceptable tool; only retards and lepers use it for
>anything

Why, aren't we in a special mood. Mama forget to put a Twinkie in your
lunch today?

--
Zilbandy - Tucson, Arizona USA <z...@zilbandyREMOVETHIS.com>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilbandy.com/pgpkey.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[aaron...@gmail.com]

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

[Zilbandy]

On 27 Nov 2006 17:44:11 -0800, "aaron...@gmail.com"
<aaron...@gmail.com> wrote:

>you idiots are stuck in the 1st grade of the technology ladder

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.

[Master Programmer]

Fuck 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

[aaron...@gmail.com]

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?

fuck excel and anyone that uses it

-Aaron

[Zilbandy]

On 28 Nov 2006 00:35:53 -0800, "Master Programmer"
<master_p...@outgun.com> wrote:

>Fuck 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 !

Hey, butt ooze, I may be fat, but you're ugly, and I can diet! And,
apparently, I care, thank you for your comments.

>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

You guys lost the war in the late 1700's. You got no say in the matter
any longer. ROFLMFAO

>The Grand Master

You know, I thought I saw you down at the lake working in the Bait and
Tackle shop last weekend. Why not use your entire title, don't be
shy... "The Grand Master Baiter"?

[Master Programmer]

> Hey, butt ooze, I may be fat, but you're ugly, and I can diet! And,
> apparently, I care, thank you for your comments.

You havnt seen me. I saw a pic of you on your site lard ass.

> You guys lost the war in the late 1700's. You got no say in the matter
> any longer. ROFLMFAO

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

[aaron...@gmail.com]

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

[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

[aaron...@gmail.com]

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

[aaron...@gmail.com]

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

[Master Programmer]

> just because Syria and Iran have been assisting the resistance; does
> that mean that we haven't done our jobs?
>

Yeah right ! And you won the war in Vietnam too - ha ha.

> 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.

Why not just let the rag heads just keep their filthy sandpit.

> Mother fucking Saddam Hussein was paying people to blow themselves up
> in the WEST BANK.

Great, a few less jews to have to bother with. The should withdraw any
support for Israel, its a country that should not exist.

> Mother fucking Saddam Hussein _WAS_ building WMD; he probably gave them
> to Syria or Iran so that we wouldn't find them.
>

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.

> 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?
>

I have 3 citizenships, if my country goes too war I just change
country.

Steve Ray Irwin
The Grand Master

[Master Programmer]

No I got raj_p...@asia.com. 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 cunt.

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

[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

[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

[aaron...@gmail.com]

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

[jlepack]

Steve Irwin was Australian...

Cheers!

[aaron...@gmail.com]

yeah no shit he's australian

you British kids still militarily occupy Australia and 1/4 the land
mass of the world right?

but then when other mainland powers want to have a few colonies; you
bitch to the good old yankees to come and bail you out?

[Master Programmer]

Yeah, thats Steve "Ray" Irwin

The Grand Master

[Master Programmer]

They have crocodiles here. Alligators are the smaller weaker ones found
in america.

The Grand Master

[aaron...@gmail.com]

god damn.. thats' just about the funniest thing i've ever seen in my
life.

run around and chage the base data?

ROFL

it's funny.. if Excel actually had some sort of 'procedural' or 'action
query' type funcitonality; it might be really really powerful.

i mean seriously here.. no coding; but some way to create 'action
queries' in excel that would do the simple stuff; copy from range A to
range B... copy formuals from range A to a new range on a new page and
called it 'range x'

Access has this sort of funcitonality; and you don't need to write
code.

Excel VBA is the most critical threat anywhere in the world; and you
fukrs should not rely on it for anything.

Doesn't Norton even disable Excel Macros by default? Lol

-Aaron