Рет қаралды 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:
amzn.to/3xtLmXp
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#ExcelTextSplitFunction
#ExcelSplitStrings