Automatically capitalize an Excel entry
afarni
Posted messages
155
Status
Member
-
cs_Le Pivert Posted messages 8437 Status Contributor -
cs_Le Pivert Posted messages 8437 Status Contributor -
Hello,
in an Excel table, I would like to automate the input in uppercase for columns A and B.
I followed the usual templates, column B = Uppercase, etc. Then I copy-pasted values, etc. It works for all the cells in uppercase, but when I input a new cell below that is empty, despite the copy-paste values, it remains in lowercase.
Does anyone know a solution?
Thank you!
in an Excel table, I would like to automate the input in uppercase for columns A and B.
I followed the usual templates, column B = Uppercase, etc. Then I copy-pasted values, etc. It works for all the cells in uppercase, but when I input a new cell below that is empty, despite the copy-paste values, it remains in lowercase.
Does anyone know a solution?
Thank you!
6 answers
-
Hello,
here is a small utility. You just need to open it and then close it. In all workbooks, a contextual menu is available to convert text to uppercase, lowercase, sentence case, title case, column uppercase, and column lowercase. There is also a delete mode for the contextual menu. A link in the workbook to set it as an add-in is included.
http://www.cjoint.com/c/GBtqhGLVxYQ
--
@+ The Woodpecker
