Textafter & Textbefore in Excel to Extract Cell Contents
Quick video that will save me time in the future. The newer formula in Excel allows you to extract text before or after a delimiter. In our case, we are using addresses and want to extract the number from the street. This allowed for a quick ROUNDDOWN to the hundred block then join the cells back together to identify high count streets in a Pivot Table
Note: Did use =CONCAT to join the two cells back together for the Pivot Table. You could use =TEXTJOIN
Before: =TEXTBEFORE
After: =TEXTAFTER
Round down: =ROUNDDOWN
Join cells: =CONCAT