TEXTSPLIT Function - Splits text strings used with LEN Function and TRIM Function
The TEXTSPLIT function enables you to break text strings using specified column and row separators. This function mimics the functionality of the Text-to-Columns wizard but in the form of a formula. You can use it to divide text either horizontally into columns or vertically into rows. Essentially, it serves as the counterpart to the TEXTJOIN function. I'll use TEXTSPLIT with the TRIM Function to remove any unnecessary spaces.
Chapters/Bookmarks
0:00 Intro
0:18 TEXTSPLIT Function
1:30 LEN Function
1:47 TRIM Function
Syntax
=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])
The TEXTSPLIT function syntax has the following arguments:
text - The text you want to split. Required.
col_delimiter The text that marks the point where to spill the text across columns.
row_delimiter The text that marks the point where to spill the text down rows. Optional.
ignore_empty Specify TRUE to ignore consecutive delimiters. Defaults to FALSE, which creates an empty cell. Optional.
match_mode Specify 1 to perform a case-insensitive match. Defaults to 0, which does a case-sensitive match. Optional.
pad_with The value with which to pad the result. The default is #N/A.
TEXTSPLIT Availability:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, and Excel for the web
FUNCTIONS Used in this video
TEXTSPLIT
LEN
TRIM
And make sure you subscribe to my channel!
- EQUIPMENT USED --------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6
- SOFTWARE USED --------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Sur cette page du site, vous pouvez voir la vidéo en ligne TEXTSPLIT Function - Splits text strings used with LEN Function and TRIM Function durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Chris Menard 18 septembre 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 1,468 fois et il a aimé 57 téléspectateurs. Bon visionnage!
