Excel Challenge - Extract special characters Excel (Gsheets)
Extract special characters excel - This video shows Excel formulas to extract special characters from a string, I also added googleSheets for the same extract
Link to Excel workbook:
https://docs.google.com/spreadsheets/...
00:00 Introduction
00:28 Problem Description
01:39 Logic Breakdown
05:22 Approach 1 -Concat/textsplit
07:16 Option 2 - Reduce function
12:13 GoogleSheets