Microsoft Excel - Random Password Generator (with character-based color coding)
Автор: BCTI
Загружено: 2026-01-18
Просмотров: 693
Learn how to create a random password generator using 3 Excel functions: RANDARRAY, CHAR, and TEXTJOIN. Plus, get the free code to change each character in a cell to a different color based on the type of data (i.e., letters vs. numbers vs. symbols).
Personal Macro Workbook - Video Link:
• VBA - Personal Macro Workbook (in Excel)
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:03 Demonstration Overview
00:59 File Download Instructions
01:06 Functions Used in the Project
01:15 Formulas Overview
01:33 Generating Random Fractional Numbers
02:51 Turning the Numbers into Characters
03:33 ASCII Table Example
04:11 F9 Key to Re-randomize
04:36 Combining the Characters Into a Single Cell
05:52 Freezing the Results
06:25 Keyboard Shortcut for "Paste Values"
06:57 Overcoming Confusing Fonts
07:35 Manually Changing Single Character Color
08:00 Auto Color Characters Based on Character Type
08:44 Personal Macro Workbook - Video Link
09:44 Making the User Input Dynamic
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: