Excel How To Convert Case (Upper Lower Proper)

preview_player
Показать описание

This short video demonstrates three ways to convert the case of text to upper, lower, and proper. Specifically, it shows how to use Flash Fill, formulas, and Power Query.

Chapters in this video:
00:00 - Introduction
00:13 - Flash Fill
01:16 - Formulas
01:55 - Power Query

Also, check out these videos with time saving Excel Hacks:

Рекомендации по теме
Комментарии
Автор

Formulas can spill out:
=PROPER(C10:C20)
=UPPER(D10:D20)
=LOWER(E10:E20) 🤗

JoseAntonioMorato
Автор

Great video thank you, but what I want is to change my original columns, you have created extra columns with results, how can I change the original columns. Only flash fill helps with this. sorry I am only a beginner, but find your content very useful.

Excel
Автор

if only it was that simple with "Mc" surnames! 😁

underpants