Excel TextSplit Function

preview_player
Показать описание
This video looks at the TEXTSPLIT Function in Excel. This Function can be used to split/parse strings in a spreadsheet based on a delimiter or multiple delimiters that you specify. This video shows the following types of examples:

1. Single Character Delimiters
2. 2 or More Types of Delimiters for the same String
3. Multi-Character or Word String Delimiters
4. Column Delimiters & Vertical Row Delimiters
5. Ignoring Empty Values when Delimiting
6. Setting Delimiters to be Case Insensitive

Learn more about Excel Functions & Features with this book at Amazon:

Get a Microsoft Office 365 Personal Subscription with this Amazon link:

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.

#ExcelTextSplitFunction
#ExcelSplitStrings
Рекомендации по теме
join shbcf.ru