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!
In questa pagina del sito puoi guardare il video online TEXTSPLIT Function - Splits text strings used with LEN Function and TRIM Function della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Chris Menard 18 settembre 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 1,468 volte e gli è piaciuto 57 spettatori. Buona visione!
