# Excel: Changing cases

**URL:** <https://boards.straightdope.com/t/excel-changing-cases/468950>\
**Category:** Factual Questions\
**Created:** [October 21, 2008, 9:37pm UTC](https://boards.straightdope.com/t/excel-changing-cases/468950 "2008-10-21T21:37:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Johnny\_L.A](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/johnny_l.a/32/1084_2.png) [@Johnny\_L.A](https://boards.straightdope.com/u/Johnny_L.A)\
**Post date:** [October 21, 2008, 9:37pm UTC](https://boards.straightdope.com/t/excel-changing-cases/468950/1 "2008-10-21T21:37:05Z")

</div>

I’m sure this is an easy one, but I can’t seem to find the control to change the case of the text. I have mixed-case, and I want to change everything to upper-case.

So where’s the button?

---

<div class="post-metadata">

**Author:** ![Shayna](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/shayna/32/17976_2.png) [@Shayna](https://boards.straightdope.com/u/Shayna)\
**Post date:** [October 21, 2008, 9:59pm UTC](https://boards.straightdope.com/t/excel-changing-cases/468950/2 "2008-10-21T21:59:05Z")

</div>

No easy button, but [it can be done](http://support.microsoft.com/kb/263580). 🙂

---

<div class="post-metadata">

**Author:** ![Johnny\_L.A](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/johnny_l.a/32/1084_2.png) [@Johnny\_L.A](https://boards.straightdope.com/u/Johnny_L.A)\
**Post date:** [October 21, 2008, 11:18pm UTC](https://boards.straightdope.com/t/excel-changing-cases/468950/3 "2008-10-21T23:18:46Z")

</div>

Yikes, what a PITA! Especially since the case gets changed automatically downstream anyway.

Thanks for the link!

🙂