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

If so how?

You can use the UPPER function:

=UPPER(A1)

Hope this helps.

Pete

On Dec 17, 6:45*pm, Chris K <Chris
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
wrote:
Can you change current small text in a cell to CAPITALS?

If so how?

.