Excel Formula Challenge - REDUCE function for Pascal Case to Snake Case
This Video demonstrates a formula solution to converting Pascal case to Snake case. The REDUCE function once again comes in handy for this task
Chapters:
00:00 Introduction
00:36 Reading the problem
02:30 A little about CODE/CHAR functions
03:34 A practical walkthrough of the solution concept(Demo)
06:35 A case for the REDUCE function, why it works!
07:37 Solution proper -REDUCE Function - step-by-step
12:10 Adding Replace/Substitute/MID to the solution
13:22 Final thoughts on REDUCE and the solution
Link to Excel Workbook:
https://docs.google.com/spreadsheets/...
Link to Excel Challenge:
https://www.linkedin.com/posts/excelb...