How to extract text before first comma or space

This video will show you how to get text before the first comma in a text string using a formula or User defined function with vba code in excel 2013/2016/2019/365.

Time Stamps
00:00:11 Method 1: Extract Text Before First Comma or Space Using Formula
00:01.14 Method 2: Extract Text Before First Comma or Space with VBA Macro

#########
#########