software

how do you make caps all text?--
librarian
------------------------------------------------------------------------
librarian's Profile: www.excelforum.com/member.php...oamp;userid=34474
View this thread: www.excelforum.com/showthread...hreadid=542333You can use the formula UPPER. For example, to make the contents of cell A1
all caps the formula will look like:
=UPPER(A1)

Hope this helps,
Miguel.

quot;librarianquot; wrote:

gt;
gt; how do you make caps all text?
gt;
gt;
gt; --
gt; librarian
gt; ------------------------------------------------------------------------
gt; librarian's Profile: www.excelforum.com/member.php...oamp;userid=34474
gt; View this thread: www.excelforum.com/showthread...hreadid=542333
gt;
gt;