Can you change current small text in a cell to CAPITALS? 

If so how?

You can use the UPPER function:

=3DUPPER(A1)

Hope this helps.

Pete

On Dec 17, 6:45=A0pm, Chris K <Chris K...@discussions.microsoft.com>
wrote:
> Can you change current small text in a cell to CAPITALS?
>
> If so how?

per teh functions list for TEXT data, UPPER will convert all the text into 
all capital letters

"Chris K" wrote:

> Can you change current small text in a cell to CAPITALS? 
> 
> If so how?

To add on to Pete's answer,  You can highlight the results from Column B 
(assuming that's where you did Pete's formula) and Copy.  Go to Column A and 
do Paste Special, Values. Then you can clear out/delete Column B and you'll 
be back to square one, but with everything in CAPS.
-- 
-Kaman
The IT dept people call before they call the real IT dept.


"Pete_UK" wrote:

> You can use the UPPER function:
> 
> =UPPER(A1)
> 
> Hope this helps.
> 
> Pete
> 
> On Dec 17, 6:45 pm, Chris K <Chris K...@discussions.microsoft.com>
> wrote:
> > Can you change current small text in a cell to CAPITALS?
> >
> > If so how?
> 
> .
>