How to split text with multiple delimiters with Excel - Excel Tips and Tricks

Learn how to split text with multiple delimiters in Excel. We will be answering questions too. Can you have multiple delimiters in Excel, in another words how to use text to column delimiter multiple characters in Excel? We will also aspire to answer how do I separate multiple lines of text in one cell in Excel, and how do I split a text string into characters in Excel?

Splitting text (single delimiter type)
=TEXTSPLIT(A2,",")

Splitting text (multiple delimiter types)
=TEXTSPLIT(A3,{",",".",";",";;","/",":"})

Formula
=TRIM(TEXTSPLIT(A3,{",",".",";",";;","/",":"}))

Formula
=TRANSPOSE(TEXTSPLIT(A3,{",",".",";",";;","/",":"}))


Can you have multiple delimiters in Excel?,How to use text to columns delimiter multiple characters in Excel?,How do I separate multiple lines of text in one cell in Excel?,How do I split a text string into characters in Excel?,