ExcelBanter - format cell to capitlize

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - format cell to capitlize (https://www.excelbanter.com/excel-worksheet-functions/31959-format-cell-capitlize.html)

Sonia

format cell to capitlize

How can I format a cell to capitize whatever is in ther automatically?

Ron de Bruin

You can use VBA code or use Data validation

Maybe you like this without code

Select Column A
Data Validation:(choose custom)

=EXACT(A1,UPPER(A1))

You can only type in Uppercase now

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Sonia" wrote in message ...
How can I format a cell to capitize whatever is in ther automatically?

All times are GMT +1. The time now is 10:51 PM.