change case in excel

J

joe

can someone tell me where to find the "add in" that converts the case text
from lower to upper in excel. i've already downloaded this before but can't
remember where from and it is much easier than creating a formula or a macro
 
D

Duke Carey

You don't need an add-in. Just use the UPPER() function.

=UPPER("joe") will give you JOE.
 
J

joe

Duke

Thanks but this is not a quick or convenient way to change whole documents,
columns or rows. There is a very simple excel add in that can be downloaded
and and is accesible on the toolbar which is really starightforward.
 
J

joe

Gord

Having downloaded the addin i cant remember how to how to import it into the
worksheet. i seem to recall that you can place the add in on a toolbar but
again cant remember how to do it.

Joe
 
G

Gord Dibben

Joe

Do not import the add-in to the workbook.

Unzip the download from Chip's site.

Move the Caseconvert.xla add-in to your Office\Library folder then in
Tools>Add-ins checkmark it.

You will find a "Convert Text" menu item added to the Tools menu.

Select your text and Tools>Convert Text.


Gord Dibben Excel MVP
 
J

joe

thanks Gord. interestingly this is not the addin that i've used before as i
can't see any way to include it on a toolbar (which makes life even easier)
never the less it does the job...thanks again.
 
G

Gord Dibben

Joe

Place a button on your toolbar pointing to the macro "ShowCaseConvertForm"
which can be found in the "ModMain" module.

Chip's code is open so you can see the form and module in the VB Editor.

If you don't want the "Convert Text" sub-item on the Tools Menu, just rem out
or delete the Auto_Open and Auto-Close subs.

Sorry about that Chip...........butchering your add-in<g>


Gord
 
Top