Excel TextSplit Function

Опубликовано: 02 Октябрь 2024
на канале: The Excel Cave

133

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:
https://amzn.to/3xtLmXp

Get a Microsoft Office 365 Personal Subscription with this Amazon link:
https://amzn.to/3aV9GtL

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

#ExcelTextSplitFunction
#ExcelSplitStrings