ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   In Excel, can you change uppercase letters to lowercase (https://www.excelbanter.com/new-users-excel/156989-excel-can-you-change-uppercase-letters-lowercase.html)

mdh6245

In Excel, can you change uppercase letters to lowercase
 
I am working on a spreadsheet with numerous text entries in all uppercase and
would like to change to lowercase. Is there a simple solution to this matter?

JE McGimpsey

In Excel, can you change uppercase letters to lowercase
 
See

http://www.mvps.org/dmcritchie/excel/proper.htm#lower


In article ,
mdh6245 wrote:

I am working on a spreadsheet with numerous text entries in all uppercase and
would like to change to lowercase. Is there a simple solution to this matter?


Gord Dibben

In Excel, can you change uppercase letters to lowercase
 
With QWERTY in A1, enter =LOWER(A1) in B1 to get qwerty


Gord Dibben MS Excel MVP

On Tue, 4 Sep 2007 13:28:01 -0700, mdh6245
wrote:

I am working on a spreadsheet with numerous text entries in all uppercase and
would like to change to lowercase. Is there a simple solution to this matter?




All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com