I have columns that the user enters x or nothing. Purely for aesthetics I
would like it to auto-capitalize, so I entered the function "=UPPER(+F5)"
where F5 is the current cell. What shows is excatly what I just entered: ie.,
the function! So there are two questions, why do I have the =UPPER etc
displaying in the cell and is it the correct use of the function to uppercase
the contect in the cell.
Excel 2007.
Many thanks!
Ron

Hi,

the correct syntax is

=Upper(f5)

Mike

"Ron Carr" wrote:

I have columns that the user enters x or nothing. Purely for aesthetics I
would like it to auto-capitalize, so I entered the function "=UPPER(+F5)"
where F5 is the current cell. What shows is excatly what I just entered: ie.,
the function! So there are two questions, why do I have the =UPPER etc
displaying in the cell and is it the correct use of the function to uppercase
the contect in the cell.
Excel 2007.
Many thanks!
Ron

Nope. tried it both ways, with and without the +.
Ron

"Mike H" wrote:

Hi,

the correct syntax is

=Upper(f5)

Mike

"Ron Carr" wrote:

I have columns that the user enters x or nothing. Purely for aesthetics I
would like it to auto-capitalize, so I entered the function "=UPPER(+F5)"
where F5 is the current cell. What shows is excatly what I just entered: ie.,
the function! So there are two questions, why do I have the =UPPER etc
displaying in the cell and is it the correct use of the function to uppercase
the contect in the cell.
Excel 2007.
Many thanks!
Ron

You cannot use a formula to change a cell that has something in it.
If F5 has x then the formula =UPPER(F5) in some OTHER cell will display X

You seem to want the cell F5 where the user types an x to automatically
change to a capital X
This would require some VBA code. Are you ready to enter that area of Excel?

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ron Carr" wrote in message
...
I have columns that the user enters x or nothing. Purely for aesthetics I
would like it to auto-capitalize, so I entered the function "=UPPER(+F5)"
where F5 is the current cell. What shows is excatly what I just entered:
ie.,
the function! So there are two questions, why do I have the =UPPER etc
displaying in the cell and is it the correct use of the function to
uppercase
the contect in the cell.
Excel 2007.
Many thanks!
Ron