View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jacquie
 
Posts: n/a
Default In excel , is there a way i can change UPPERCASE to lowercase?

Thanks David...this was very helpful!

"David Billigmeier" wrote:

Try this, lets say your original values are in column A, in the range
A1:A1000. Place the formula =LOWER(A1) in B1 and drag all the way down to
B1000. Then, copy the B1:B1000 range, right-click on A1, click "Paste
Special..." and select "Values".

Use this technique to the cells you want to change, I used column's A and B
in this example.


--
Regards,
Dave
<!--


"Maria" wrote:

david, thank you for your help. when i tried doing that the original writing
disappeared.

Thanks
Maria

"David Billigmeier" wrote:

Actually there is a way in Excel... use the =LOWER() function.

Example:
=LOWER("UPPER CASE TEXT") will return "upper case text"


--
Regards,
Dave
<!--


"Mike" wrote:

I dump it into word, change to lowercase and dump it back to excel.
Excel does not have this.

"Maria" wrote:

Please e-mail me back ASAP, if there's a way to do this in Excel... I know
WORD has it, but I can't seem to find it EXCEL