UPPERCASE (EXCEL) Solved

Question

Hello everyone, I am currently creating an Excel file where one column contains words in lowercase and uppercase. I would like to know, not knowing much about Excel, if it is possible to select the said column and format all its content in uppercase (all the cells at once, I mean). Thank you immensely in advance to those of you who could help me (I have a lot of rows but only one column to modify).  http://abarka.free.fr An adult sitting sees further than a young person standing.

VIRGIL · Accepted Answer

There is the UPPER() function (or MAJUSCULE() in French), but it requires some manipulations: Create a new column, set the value to: UPPER(A1), then copy this value down the entire column. Select this column and paste it using Paste Special / Values.

However, to convert simple text in Excel (or one or more columns) from lowercase to uppercase, you just need to copy/paste the cells to be modified and put them into a Word page.

On this Word page, select all
Press the keys: CTRL+SHIFT+A (everything turns to uppercase...)
Then, simply select all to COPY (on this Word page)
Then return to the original Excel sheet to do a SPECIAL PASTE, a window will appear, and you need to click on TEXT (the last line of this window)
And it's done.
I just found this trick this morning, taking into account the remarks from previous responses... (the "special paste" phase was the only thing missing for it to work).

For your information, there is a direct function in Excel, without going through Word; I did it unconsciously, but I can't remember the keyboard shortcuts that allow me to do this...

Best regards

VIRGIL

metathesus · Answer

http://www.info-3000.com/excel/majuscule.php  @pluch! ;-) Il n'y a pas de problèmes ! Seulement des défis supplémentaires !

Pajeclo · Answer

The combination is "shift+F3"  Good evening

lesioux · Answer

There is an Excel function called UPPER that changes lowercase letters to uppercase.  There you go!   lesioux

Moimeme · Answer

It doesn't work at all. It gives "=UPPER("#NAME?")" or "=UPPER("pc")" as a result and not the text in uppercase.

Patrice33740 · Answer

Good evening,

if it displays =UPPER("pc") instead of PC, it means the cell's number format is set to "Text".

Change it to "General" (right-click, Format Cells, Number tab, General) and then re-enter the formula.

--
Nicolas always says: "It's easy when you know the answer!"

Mytå · Answer

Hello forum  Try using UPPER instead of MAJUSCULE  Mytå -- Thank you for responding to your question, we are not robots... Installed versions [MsProject 2003(FR), Excel 2003-2007(FR)]

WISCH91 · Answer

To simplify (compared to Word) in 5 steps in Excel (any version):
1. Add a column with the formula =UPPER(cell name in lowercase) on all the rows to modify (e.g. =UPPER(A1)) as written in the posts above. You will have the data in uppercase, but in 2 columns, which is not practical!
2. Select this modified column (or the modified range),
3. Copy this column (or this range) (Ctrl + C)
4. Perform a special paste with the option "Values (Office 2003)" or "paste values (Office 2010)" and insert the created column with the uppercase values where needed in your table...
5. Delete the original column and the column containing the formulas.

I just did it on a list of 200 cities written in all sorts of ways, and it's perfect!
Good luck to everyone!

Raymond PENTIER · Answer

In addition to all the solutions proposed over the past 9 years (yes, this discussion dates back to 2003!), there is the one that simply consists of using a Copperplate, Stencil, Felix Titling, or Algerian font for the entire area concerned: these fonts only contain uppercase letters...
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂

Raymond PENTIER · Answer

Hello everyone.

Given the number of conflicting and sometimes false information contained in this discussion, it is important to remind that:
- In Excel, there is no keyboard shortcut to change lowercase to uppercase.
- The shortcut CTRL+SHIFT+A and the shortcut SHIFT+F3 only work in Word.
- The UPPER function in English Excel is the MAJUSCULE function in French Excel!

--
Retirement is great! Especially in the Antilles... :-)
Raymond (INSA, AFPA, CF/R)

Tout en majuscules (excel)

10 answers

Jbl 500 bt one-sided issue.

Remove youtube from freebox pop apps

Subliminal image in a video

I'm looking for java or jar game sites.

How to unsubscribe from jm plan cul

Edit ad on leboncoin for free

Commun.file_upload.maxsize

Problem opening modal window from another page

Thursday modification test title number 3

How to change sources on a grundig universal remote?