change case in excel
 

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

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

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

"joe" wrote:

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

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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

I am not familiar with the add-in. Did you try a Yahoo or Google search?

"joe" wrote:

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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

Joe

Chip Pearson has an add-in for changing case on selections.

http://www.cpearson.com/excel/download.htm

Scroll down to "Case Convert"


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 05:31:27 -0700, joe wrote:

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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

Gord

Thanks it's just what i was looking for!

"Gord Dibben" wrote:

Joe

Chip Pearson has an add-in for changing case on selections.

http://www.cpearson.com/excel/download.htm

Scroll down to "Case Convert"


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 05:31:27 -0700, joe wrote:

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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

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

"Gord Dibben" wrote:

Joe

Chip Pearson has an add-in for changing case on selections.

http://www.cpearson.com/excel/download.htm

Scroll down to "Case Convert"


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 05:31:27 -0700, joe wrote:

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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

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
ToolsAdd-ins checkmark it.

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

Select your text and ToolsConvert Text.


Gord Dibben Excel MVP


On Tue, 13 Sep 2005 01:59:03 -0700, joe wrote:

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

"Gord Dibben" wrote:

Joe

Chip Pearson has an add-in for changing case on selections.

http://www.cpearson.com/excel/download.htm

Scroll down to "Case Convert"


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 05:31:27 -0700, joe wrote:

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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

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.

"Gord Dibben" wrote:

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
ToolsAdd-ins checkmark it.

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

Select your text and ToolsConvert Text.


Gord Dibben Excel MVP


On Tue, 13 Sep 2005 01:59:03 -0700, joe wrote:

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

"Gord Dibben" wrote:

Joe

Chip Pearson has an add-in for changing case on selections.

http://www.cpearson.com/excel/download.htm

Scroll down to "Case Convert"


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 05:31:27 -0700, joe wrote:

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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

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



On Wed, 14 Sep 2005 03:56:03 -0700, joe wrote:

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.

"Gord Dibben" wrote:

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
ToolsAdd-ins checkmark it.

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

Select your text and ToolsConvert Text.


Gord Dibben Excel MVP


On Tue, 13 Sep 2005 01:59:03 -0700, joe wrote:

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

"Gord Dibben" wrote:

Joe

Chip Pearson has an add-in for changing case on selections.

http://www.cpearson.com/excel/download.htm

Scroll down to "Case Convert"


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 05:31:27 -0700, joe wrote:

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.

"Duke Carey" wrote:

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

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

"joe" wrote:

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