How to make an entire column capital or lowercase in Excel

This vedio demonstrates two methods for you to make all texts in an entire column uppercase or lowercase in details.
You can follow the step-by-step guide via the following hyperlink:

[nrlyzaa]

No babbling or whatsoever. This kind of straight-forward video is Amazing. You're life saver. Thank you ! 🙏🏻

[anet]

This is the best way and may be the only correct way, most of the other explanations and methods require changing the font or writing equations or copying to other cells.

Thank you,

[hafizkazimzade]

I don't have Kutools in my Excell. How can I get it?