Making text UPPERCASE

[azizrasul]

I have a .xlsx file which cannot be macro enabled due to security issues when the Excel file is emailed.

I have some cells which when if the user types in text in lowercase, I want it automatically to go to UPPERCASE. Is this possible?

 

[JackDanIce]

Quick search via Google found several questions of similar nature:
https://www.ozgrid.com/forum/forum/...rce-a-cell-to-show-entered-text-in-upper-case

Previously asked and replies suggest macro solution only.

 

[azizrasul]

I did a Google search yesterday and I couldn't see a solution, hence this thread.

 

[JackDanIce]

Search term: "Excel force uppercase"

Results: https://www.google.co.uk/search?q=e....69i59j0l5.10202j0j7&sourceid=chrome&ie=UTF-8

Third result down is quoted in above reply.

 

[azizrasul]

I guess that would make it a .xlsm file then?

 

[daverunt]

This link says you can set up data validation to force it.
It may or may not be suitable - that's for you to investigate.

https://exceljet.net/formula/data-validation-allow-uppercase-only

 

[JackDanIce]

I guess that would make it a .xlsm file then?

I believe so, hence my comment: "Previously asked and replies suggest macro solution only."

Try daverunt's suggestion but personally I don't think it's do-able without a macro solution which would need to be saved to an .xlsm file.

 

[azizrasul]

OK thanks I will have a look.

 

[footoo]

VBA not necessary if you use a capitals font (which was also one of the suggestions in the OZGRID link) : https://www.mrexcel.com/forum/excel-questions/1064983-how-capitalize-any-text-cell.html

 

[JackDanIce]

Good luck! Appreciate it's frustrating when receiving entities refuse to allow macro solutions and standard Excel doesn't (easily) provide.

@footoo I think problem is the end user, how do you prevent user changing font if spreadsheet is sent as .xlsx?