All Caps

[Jorge]

I have a cell that currently has a formula in it.
Problem is that I would like it to display in ALL CAPS.
I know that you can use =UPPER()

But in this case it looks into another cell to perm an IF statement formula.
Can you place to formulas in the cell the IF statement then a , or and??
Is there a way to Format the present cell as ALL CAPs in the Special section
of the format cell?

thank-you

 

[Don Guillett]

Yes, since you didn't give an example, why not try HELP index for AND. While
you're there try OR also. If you don't understand come back for more help.

 

[Jorge]

Example:
We are using a formula described on this board called "=SpellNumber(A1)"
If you place a number within cell A1 this spells out the number accordingly
in A2

A1 A2 (=Spellnumber(A1)
100 --------- one hundred

We want to get the data that appears in A2 all caps ONE HUNDRED
I know you can go to another cell and type =UPPER(A2) and it will perform
this
I was wondering if you could have it all done within the same cell?

 

[Gord Dibben]

Jorge

Just guessing here but......

A1 contains jorge
A2 contains gord

In A3 enter =UPPER(A1 & " and " A2)

Returns JORGE AND GORD

If no help, perhaps more detail on what your cells contain and a formula
example.

Gord Dibben XL2002

 

[Jorge]

I have placed a formula in the post.
Thank you.

Example:
We are using a formula described on this board called "=SpellNumber(A1)"
If you place a number within cell A1 this spells out the number accordingly
in A2

A1 A2 =Spellnumber(A1)
100 --------- one hundred

We want to get the data that appears in A2 all caps ONE HUNDRED
I know you can go to another cell and type =UPPER(A2) and it will perform
this. We were wondering if you could have it all done within the same cell?

 

[Gord Dibben]

Jorge

Try =UPPER(SpellNumber(A1))

Gord

I have placed a formula in the post.
Thank you.

Example:
We are using a formula described on this board called "=SpellNumber(A1)"
If you place a number within cell A1 this spells out the number accordingly
in A2

A1 A2 =Spellnumber(A1)
100 --------- one hundred

We want to get the data that appears in A2 all caps ONE HUNDRED
I know you can go to another cell and type =UPPER(A2) and it will perform
this. We were wondering if you could have it all done within the same cell?

 

[Jorge]

This command will work great! Thank-You!

Jorge

Try =UPPER(SpellNumber(A1))

Gord

I have placed a formula in the post.
Thank you.

Example:
We are using a formula described on this board called "=SpellNumber(A1)"
If you place a number within cell A1 this spells out the number accordingly
in A2

A1 A2 =Spellnumber(A1)
100 --------- one hundred

We want to get the data that appears in A2 all caps ONE HUNDRED
I know you can go to another cell and type =UPPER(A2) and it will perform
this. We were wondering if you could have it all done within the same cell?

Jorge

Just guessing here but......

A1 contains jorge
A2 contains gord

In A3 enter =UPPER(A1 & " and " A2)

Returns JORGE AND GORD

If no help, perhaps more detail on what your cells contain and a formula
example.

Gord Dibben XL2002