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,{",",".",";",";;","/",":"}))

#tip #excel #microsoft #shorts #short #shortvideo #shortsvideo #howto #how #google

[misterwill]

A work of art! I'm familiar with the delimiter feature for one delimiter, but not the textsplit with multiple delimiters. You even combined it to a trim argument. Thank you!!