View original (French)

Lowercase and uppercase in Excel

Solved/Closed
dieseus Posted messages 144 Status Member -  
 marvin -
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.

5 answers

  1.
    g Posted messages 1285 Status Member 578
     
    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
    130
    1. dieseus
       
      Thank you so much BIG "g".
      It works wonderfully.
      Thanks again.
      But I didn't quite understand "special paste", what is it?
      0
    2. g Posted messages 1285 Status Member 578 > dieseus
       
      In this case, "Paste Special > Values" allows you to paste only the values of cells containing formulas, while a regular paste pastes everything.
      You could thus recreate your table in lowercase, without keeping the uppercase columns.
      Good luck.

      http://perso.wanadoo.fr/gerard.g
      0