UPPERCASE (EXCEL)
Solved
txiki
Posted messages
6514
Registration date
Status
Contributeur
Last intervention
-
Avatar -
Avatar -
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.
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.
10 answers
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
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
Pingu
A big thank you for the info!
hair
not a bad tip, thanks
