Text Split with multiple delimiters - Excel Tips and Tricks

Learn how to text split with multiple delimiters in Excel.

In Excel, you can split text with multiple delimiters by using the "Text to Columns" feature. This tool allows you to specify multiple delimiters, such as commas, semicolons, or custom characters, to divide your text into separate columns.

Lets break down this formula

=TEXTSPLIT(TEXTJOIN({",",";","-"},TRUE,B3:C3),{",",";","-"})

If B3 contains "Apple,Banana" and C3 contains "Cherry;Date", the TEXTJOIN function combines them into "Apple,Banana,Cherry;Date".
The TEXTSPLIT function then splits this string into an array with four elements: ["Apple", "Banana", "Cherry", "Date"].
So, the formula takes two cells with text, combines them into a single text string with specific delimiters, and then splits that text string into an array of elements.


🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
Sum comma separated values in Excel - Excel Tips and Tricks
https://youtube.com/shorts/1GUx7zi2wzc?si=Rc8Oidvtr6t-dOFV

Sum comma separated values in Excel Without Using TEXTSPLIT() Function - Excel Tips and Tricks
https://youtube.com/shorts/z6ghCP7G3ew?si=rIS6nZL31jA41g17

Separate data from one cell in Excel with commas - Excel Tip and Tricks
https://youtube.com/shorts/xuhpFwb5TWg?si=8YYj22Elb2Ez2rMp

Text Split with multiple delimiters - Excel Tip and Tricks
https://youtube.com/shorts/LXZkMlGZWXQ?si=v-ovLGoZ2SdQ-baC

[NO FORMULA] Separate data from one cell in Excel with commas - Excel Tip and Tricks
https://youtube.com/shorts/4AhokAuE5Nc?si=ObQffk0YBaj0SgyU

Sum comma separated values in jaggered format in Excel - Excel Tips and Tricks
https://youtube.com/shorts/ijC7qhRK6s0?feature=share

Get maximum of comma-separated values in a cell In Excel - Excel Tips and Tricks
https://youtube.com/shorts/UHdjAsSx6C8?feature=share

Sum comma separated values in Google Sheets - Excel Tips and Tricks
https://youtube.com/shorts/bYOX6V_iWnI?feature=share


How do you split text with multiple delimiters in Excel?,How do you split text multiple delimiters in Google Sheets?,Can you use strtok with multiple delimiters?,Can a delimiter be multiple characters?,How do you split Text in Excel cell into multiple cells by character count?,How do I delimit multiple columns in Excel?,How does Text to column handle multiple characters?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks