excel office 2000 uppercase

Sure, A1 houses my Text "Denis", B1 and B2 contain the formulae to convert this to uppercase and lower case:

<CENTER&gt;<TABLE borderColor=#c0c0c0 cellSpacing=0 width="60%" align=center border=1&gt;<TBODY&gt;<TR&gt;<TD bgColor=#0c266b colSpan=5&gt;<TABLE width="100%" align=center border=0&gt;<TBODY&gt;<TR&gt;<TD align=left&gt;<FONT color=white&gt;<B&gt;Microsoft Excel - Book1</B&gt;</FONT&gt;</TD&gt;<TD align=right&gt;<FONT color=white size=2&gt;___Running: xl2000 : OS = Windows NT 4 </FONT&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD bgColor=#d4d0c8 colSpan=5&gt;<TABLE height=10 width="100%" align=center border=0 VALIGN="MIDDLE"&gt;<TBODY&gt;<TR&gt;<TD&gt;(<U&gt;F</U&gt;)ile (<U&gt;E</U&gt;)dit (<U&gt;V</U&gt;)iew (<U&gt;I</U&gt;)nsert (<U&gt;O</U&gt;)ptions (<U&gt;T</U&gt;)ools (<U&gt;D</U&gt;)ata (<U&gt;W</U&gt;)indow (<U&gt;H</U&gt;)elp</TD&gt;<TD vAlign=center align=right&gt;<FORM name=formCb5705&gt;<INPUT onclick='window.clipboardData.setData("Text",document.formFb4266.sltNb5992.value);' type=button value="Copy Formula" name=btCb2288&gt;</FORM&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD bgColor=white colSpan=5&gt;<TABLE border=0&gt;<TBODY&gt;<TR&gt;<FORM name=formFb4266&gt;<TD align=middle width="5%" bgColor=white&gt;<SELECT onchange="document.formFb4266.txbFb6925.value = document.formFb4266.sltNb5992.value" name=sltNb5992&gt;<OPTION value==UPPER(A1) selected&gt;B1<OPTION value==LOWER(B1)&gt;B2</OPTION&gt;</SELECT&gt;</TD&gt;<TD align=right width="3%" bgColor=#d4d0c8&gt;<B>=</B&gt;</TD&gt;<TD align=left bgColor=white&gt;<INPUT size=120 value==UPPER(A1) name=txbFb6925&gt;</TD&gt;</FORM&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<BR&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;A</CENTER&gt;</B&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;B</CENTER&gt;</B&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;C</CENTER&gt;</B&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;D</CENTER&gt;</B&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;1</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;Denis</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb4266.sltNb5992.options[0].selected=true; document.formFb4266.txbFb6925.value = document.formFb4266.sltNb5992.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;DENIS</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;2</CENTER&gt;</B&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb4266.sltNb5992.options[1].selected=true; document.formFb4266.txbFb6925.value = document.formFb4266.sltNb5992.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;denis</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD colSpan=5&gt;<U&gt;Sheet1</U&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;<BR&gt;<FONT color=#339966&gt;To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT&gt;<BR&gt;<FONT color=red size=2&gt;PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT&gt;<BR&gt;<BR&gt;<FONT color=#339966 size=1&gt;The above image was automatically generated by [HtmlMaker 2.12] </FONT&gt;<FONT color=#339966 size=1&gt;If you want this FREE SOFT, <A href="http://www.interq.or.jp/sun/puremis/colo/HtmlMaker.htm"&gt;click here</A&gt; to download</FONT&gt;<BR&gt;<FONT color=#339966 size=1&gt;This code was graciously allowed to be modified: by <A href="mailto:[email protected]"&gt;Ivan F Moala</A&gt; All credit to <A href="mailto:[email protected]"&gt;Colo</A&gt;</FONT&gt;<BR&gt;</CENTER&gt;

The free addin from http://www.asap-utilities.com might help.

In the Text menu provided by this there is an option to make a selected range, Upper Case. Lower Case, start each word with Upper Case. A combination which usually tidies up any Text.

There are 300+ functions in this addin and it is well worth familiarising yourself with it

Bruno:

Easiest way without installing anything or using VBA code...

**Click on the letter B and hit Insert-Column.

Now, in cell B1 (which is now blank, right?), type this (Dennis' formula):

=upper(A1)

and hit Enter.
Now, click on cell A1 and you'll see a small black box at the bottom-right corner of the cell. Double-click that little box with your cursor. It should copy the formula you wrote all the way down. Double-check to make sure it did that. If not, then click and drag that corner box all the way down to copy the formula for all your rows.

Now, column B should contain the same info as column A except it's all capped.

Click on cell B1.
Hold the Ctrl+Shift keys and hit your Down arrow key one time and let go of all the keys.
That should select all those new upper-case cells you made.
Hit Ctrl+C.
Now, from the menu, hit Edit-Paste Special. Tic the "Values" mark and hit OK.
That should turn your formulas into the upper case text you wanted, which now makes it save for you to click on the letter A to highlight column A and then Edit-Delete.

Repeat from ** for each column that you have, remembering that you'll be changing the cell references I gave you too.

Hope this helps!

The example is to show you how to use the UPPER and LOWER functions. Not to solve your problem. There wasn't enough information to solve your specifc problem.

To use the UPPER function, you simply type "=UPPER(CellReference)" into a specific cell, where "CellReference" is the cell that has the text you want to convert to UPPERCASE e.g.

<CENTER&gt;<TABLE borderColor=#c0c0c0 cellSpacing=0 width="60%" align=center border=1&gt;<TBODY&gt;<TR&gt;<TD bgColor=#0c266b colSpan=5&gt;<TABLE width="100%" align=center border=0&gt;<TBODY&gt;<TR&gt;<TD align=left&gt;<FONT color=white&gt;<B&gt;Microsoft Excel - Book1</B&gt;</FONT&gt;</TD&gt;<TD align=right&gt;<FONT color=white size=2&gt;___Running: xl2000 : OS = Windows NT 4 </FONT&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD bgColor=#d4d0c8 colSpan=5&gt;<TABLE height=10 width="100%" align=center border=0 VALIGN="MIDDLE"&gt;<TBODY&gt;<TR&gt;<TD&gt;(<U&gt;F</U&gt;)ile (<U&gt;E</U&gt;)dit (<U&gt;V</U&gt;)iew (<U&gt;I</U&gt;)nsert (<U&gt;O</U&gt;)ptions (<U&gt;T</U&gt;)ools (<U&gt;D</U&gt;)ata (<U&gt;W</U&gt;)indow (<U&gt;H</U&gt;)elp</TD&gt;<TD vAlign=center align=right&gt;<FORM name=formCb7552&gt;<INPUT onclick='window.clipboardData.setData("Text",document.formFb3707.sltNb8739.value);' type=button value="Copy Formula" name=btCb8704&gt;</FORM&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD bgColor=white colSpan=5&gt;<TABLE border=0&gt;<TBODY&gt;<TR&gt;<FORM name=formFb3707&gt;<TD align=middle width="5%" bgColor=white&gt;<SELECT onchange="document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value" name=sltNb8739&gt;<OPTION value==UPPER(A1) selected&gt;B1<OPTION value==UPPER(A2)&gt;B2<OPTION value==UPPER(A3)&gt;B3<OPTION value==UPPER(A4)&gt;B4<OPTION value==UPPER(A5)&gt;B5<OPTION value==UPPER(A6)&gt;B6<OPTION value==UPPER(A7)&gt;B7</OPTION&gt;</SELECT&gt;</TD&gt;<TD align=right width="3%" bgColor=#d4d0c8&gt;<B>=</B&gt;</TD&gt;<TD align=left bgColor=white&gt;<INPUT size=120 value==UPPER(A1) name=txbFb8093&gt;</TD&gt;</FORM&gt;</TR&gt;</TBODY&gt;</TABLE&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<BR&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;A</CENTER&gt;</B&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;B</CENTER&gt;</B&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;C</CENTER&gt;</B&gt;</TD&gt;<TD align=middle bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;D</CENTER&gt;</B&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;1</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;Denis</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb3707.sltNb8739.options[0].selected=true; document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;DENIS</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;2</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;John</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb3707.sltNb8739.options[1].selected=true; document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;JOHN</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;3</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;Paul</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb3707.sltNb8739.options[2].selected=true; document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;PAUL</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;4</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;George</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb3707.sltNb8739.options[3].selected=true; document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;GEORGE</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;5</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;Pete</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb3707.sltNb8739.options[4].selected=true; document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;PETE</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;6</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;TheDeadGuyBefore Beatles were famous</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb3707.sltNb8739.options[5].selected=true; document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;THEDEADGUYBEFORE BEATLES WERE FAMOUS</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD align=middle width="1%" bgColor=#d4d0c8&gt;<B&gt;<CENTER&gt;7</CENTER&gt;</B&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<FONT face=Arial color=#000000&gt;Ringo</FONT&gt;</TD&gt;<TD vAlign=bottom align=left bgColor=#ffffff&gt;<A onclick="document.formFb3707.sltNb8739.options[6].selected=true; document.formFb3707.txbFb8093.value = document.formFb3707.sltNb8739.value;" href="javascript:void(0);"&gt;<FONT face=Arial color=#000000&gt;RINGO</FONT&gt;</A&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;<TD bgColor=#ffffff&gt;<BR&gt;</TD&gt;</TR&gt;<TR&gt;<TD colSpan=5&gt;<U&gt;Sheet2</U&gt;</TD&gt;</TR&gt;</TBODY&gt;</TABLE&gt;<BR&gt;<FONT color=#339966&gt;To see the formula in the cells just click on the cells hyperlink or click the Name box</FONT&gt;<BR&gt;<FONT color=red size=2&gt;PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</FONT&gt;<BR&gt;<BR&gt;<FONT color=#339966 size=1&gt;The above image was automatically generated by [HtmlMaker 2.12] </FONT&gt;<FONT color=#339966 size=1&gt;If you want this FREE SOFT, <A href="http://www.interq.or.jp/sun/puremis/colo/HtmlMaker.htm"&gt;click here</A&gt; to download</FONT&gt;<BR&gt;<FONT color=#339966 size=1&gt;This code was graciously allowed to be modified: by <A href="mailto:[email protected]"&gt;Ivan F Moala</A&gt; All credit to <A href="mailto:[email protected]"&gt;Colo</A&gt;</FONT&gt;<BR&gt;</CENTER&gt;

If you are wanting to convert a whole lot of values, then Dreamboat has given you a good procedure to follow.

If you want to toggle between the 3 Cases (UPPER, lower, Proper) you could use a small routine such as:

Sub ChangeCase()
If Selection.Value = LCase(Selection.Value) Then
Selection.Value = UCase(Selection.Value)
Exit Sub
End If
If Selection.Value = UCase(Selection.Value) Then
Selection.Formula = Application.Proper(Selection)
Exit Sub
End If
If Selection.Formula = Application.Proper(Selection) Then
Selection.Value = LCase(Selection.Value)
Exit Sub
End If
End Sub

Note: works ONLY with a single cell selected!
Regards, Manfred

In cell B1 type in the formula "=UPPER(A1)". Exit the cell.

Highlight cell B1 with the excel cursor (the black border thingy)..

There is a little square on the excel cursor on the bottom right hand corner. Double click on this and your formula will be copied to B7989 .

No worries.

OK just for fun i wrote this for a guy at work same kind of reasons i guess.

OK add this to a command button, froms button might be easier, and highlight all the cells in A and B COl

Hit the buton, shold do as you require

Tested in Xp Excel on Win Xp Professional

Hope this helps

Jack in the UK

Code:

Sub Jacks_Upper_Test()
Dim Rng As Range
Dim Jack_in_the_UK As Range
Set Rng = Selection.SpecialCells(xlCellTypeConstants, 2)
For Each Jack_in_the_UK In Rng
Jack_in_the_UK.Value = UCase(Jack_in_the_UK.Value)
Next Jack_in_the_UK

End Sub

:bouncy:

Sorry i had to add that smiley, i love movements

:bouncy: :bouncy: :bouncy: :bouncy:

Jack,

you should add a comment at the top :

'written by Jack_in_the_UK

...just in case someone later wonders who wrote it

:lol:

Also, you could download that excellent free add-in ASAP utilities. There's an UPPER case function on that feller.

http://www.asap-utilities.com