All Caps

  • Thread starter Thread starter Jorge
  • Start date Start date
J

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

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?
Click to expand...
 
This command will work great! Thank-You!

Gord Dibben said:
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?



Gord Dibben said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top