automatic uppercase in each cell Solved

Question

Hello
I would like to display names in uppercase systematically in each cell of a "Name" column, even if the input is in lowercase
I know there is the uppercase function but how to use it?
Thank you for your answers.

Raymond PENTIER · Accepted Answer

Another possible solution: Set the column in Algerian, Castellar, Copperplate Gothic, or Stencil font...  -- It's nice, retirement! Especially in the Caribbean... :-) &#9787; Raymond &#9794;

Anonymous user · Answer

Hello  If the proper name is in cell A1, in A2, for example, you put =UPPER(A1) to drag down the column A2   -- Argitxu

Vaucluse · Answer

Hello
I don't believe it's possible to format a cell to be uppercase by default;
the UPPER function exists, indeed, but it is used to transform a cell A into a cell B
for example:
in B1 = PROPER(A1) transforms the text from A1 into initial uppercase and the rest in lowercase
=UPPER(A1) transforms all the text into uppercase

best regards

--
To err is human, to persist is diabolical

ccm81 · Answer

Hello everyone

Maybe go through a small macro
Place yourself in the sheet to be processed
Alt-F11 to access the VBA editor
Paste this code
Adjust the concerned column

Const coMajus = "A:A" Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range(coMajus)) Is Nothing Then Target.Value = UCase(Target.Value) End If End Sub

Have a good continuation

Automatic uppercase in each cell

4 answers

Third-party cookies problems

Unable to print from my smartphone.

Very slow laptop

Unrecognized wireless mouse on my macbook pro

Enabling 4g hotspot on iphone and android

Nas dns-343 = failed to map drive

Software to work on a pdf

Message saying that my phone is compromised

How to purge my email inbox?

All-in-one pc search