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/d/1RZIhxntD07AN6w5gDoQRI8f-HbK5e2ng/edit?usp=share_link&ouid=115481529442131367093&rtpof=true&sd=true
Link to Excel Challenge:
https://www.linkedin.com/posts/excelbi_excel-excelchallenge-powerquerychallenge-activity-7007916947405172736-7yec?utm_source=share&utm_medium=member_desktop
