Excel Magic Trick 1277: Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True

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

Learn how to to Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True, and mixed single word text. See how using a space at the end of text will work, but will cause problems when counting the length of the words and text. Learn about the LEN and TRIM functions. Learn about Text Number Formatting. Learn about the Text To Columns feature.
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:06:09

Excel Magic Trick 1277: Sort Logical Values Alphabetically: false, FALSE, False, true, TRUE, True

Excel Magic Trick 0:01:54

Excel Magic Trick 1276: Impossible: Excel Online Absolute Cell References?

Excel Magic Trick 0:01:58

Excel Magic Trick 1275: Excel Online Office 365 MAXIFS function

Excel Magic Trick 0:05:42

Excel Magic Trick 1288: Why Doesn’t =ROW(1:LEN(A1)) Work?

Excel Magic Trick 0:01:59

Excel Magic Trick 1261: Flash Fill to Add Spaces to Credit Card Numbers

Excel Magic Trick 0:04:09

Excel Magic Trick 1264: Gross Pay From Start & End Date, Weekends Sun & Mon and Weekly Pay S...

Excel Magic Trick 0:02:40

Excel Magic Trick 1280: How To Get Latest Excel Updates for Insider Program: Office 365

Excel Magic Trick 0:06:24

Excel Magic Trick 1293: Single Cell 'Lookup Adding' w Proper Data Set for Myers-Briggs Tes...

EXCEL TRICK 5 0:05:55

EXCEL TRICK 5 EVEN ODD NUMBER SORTING

Excel Magic Trick 0:07:10

Excel Magic Trick 1294: Single Cell 'Lookup Adding' w Improper Data Set to Score Myers-Bri...

Excel Magic Trick 0:14:38

Excel Magic Trick 1284: History of Excel Max or Min with Conditions / Criteria (5 Examples)

Excel Magic Trick 0:09:16

Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Test

Excel Magic Trick 0:19:49

Excel Magic Trick 1285: OR Criteria & AND Criteria for Max & Min Calculations (5 Examples)

Excel Magic Trick 0:10:54

Excel Magic Trick 1281: TEXTJOIN & CONCAT New Excel 2016 functions (14 Examples of Joining Items...

NEWYES Calculator VS 0:00:14

NEWYES Calculator VS Casio calculator

Tutorial Excel (True 0:16:13

Tutorial Excel (True and False)

Excel Magic Trick 0:08:42

Excel Magic Trick 1283: MINIFS & MAXIFS Excel 2016 Functions: Max or Min with Conditions / Crite...

how to merge 0:01:16

how to merge 2 tables using an excel macro - very easy

EXCEL TRUE FALSE 0:03:46

EXCEL TRUE FALSE FUNCTION

Excel operacije(min,max,and...) 0:02:22

Excel operacije(min,max,and...)

How to Merge 0:03:17

How to Merge Multiple Cells/Columns Into One In Excel

RETI - The 0:25:05

RETI - The Power of Excel for Agents

TRICK : HOW 0:02:28

TRICK : HOW TO FILTER BOLD CELLS IN EXCEL|| MAKE EASY EXCEL

how to auto-highlight 0:10:02

how to auto-highlight entire row in excel with conditional formatting

Комментарии
Автор

Thanks Mike - I love the multiple solutions you've provided. I'm in your debt once again!

kjvstats
Автор

Other option would be to prepend not with the space but with apostrophe

leonidkoyfman