ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - caps (https://www.excelbanter.com/excel-discussion-misc-queries/88752-caps.html)

librarian

caps

how do you make caps all text?

--
librarian
------------------------------------------------------------------------
librarian's Profile: http://www.excelforum.com/member.php...o&userid=34474
View this thread: http://www.excelforum.com/showthread...hreadid=542333

Miguel Zapico

caps

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

"librarian" wrote:

how do you make caps all text?

--
librarian
------------------------------------------------------------------------
librarian's Profile: http://www.excelforum.com/member.php...o&userid=34474
View this thread: http://www.excelforum.com/showthread...hreadid=542333

All times are GMT +1. The time now is 01:07 PM.