Creating Formulas That Manipulate Text - Part - 1
Often, the work you do with Excel not only involves calculating numbers but also includes transforming and shaping data to fit your data models. Many of these activities include manipulating text strings. This video will highlight some of the common text transformation exercises an Excel user performs and in the process give you a sense of some of the text-based functions that Excel has to offer.
00:00 - Introduction
00:39 - & Operator
04:57 - Concatenate
06:24 - Concat
09:41 - Textjoin