lowercase and uppercase in Excel Solved/Closed

Question

Hi, I have a table in Excel where the input is a mix of lowercase and uppercase letters. Is there a way to change the case like in Word without having to re-enter everything? Thanks in advance.

g · Accepted Answer

Hello,
Considering that the concerned cells are in column A, enter in another column =LOWER(A1) and then copy down to the end of the data.

Then copy the column containing the formulas (text in lowercase) and perform a Paste Special Values on another sheet.
Have a nice day.

http://gerard.g.perso.orange.fr

lu · Answer

Hi use Excel functions: Insert menu / function / text / uppercase or lowercase  bye

rocache · Answer

Hi Dieseus
On Excel, it's not possible to change the case.
When I need to do it, I copy it to Word, change the case and paste it back in Excel
Not ideal, but it works

Keep us updated Rocache
Snow in November, Christmas in December

belmi · Answer

Go to the formula menu, then text, and choose Lowercase or Uppercase as appropriate for the cell.

papa · Answer

No need to put the value in a different column. Just enter =lower or =upper before the formula. For concatenating two cells, for example, we will enter the following formula: =LOWER(C2&B2)

Lowercase and uppercase in Excel

5 réponses

Texture issues in enshrouded

Canon mb5350 - cartridge replacement impossible

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.