Excel TextSplit Function

Published: 03 September 2023
on channel: The Excel Cave
133
6

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


On this page of the site you can watch the video online Excel TextSplit Function with a duration of hours minute second in good quality, which was uploaded by the user The Excel Cave 03 September 2023, share the link with friends and acquaintances, this video has already been watched 133 times on youtube and it was liked by 6 viewers. Enjoy your viewing!