Is there a text split function in Excel? - Excel Tips and Tricks - video Dailymotion

RobertBarone

In this video, I'll answer the question to is that a text split function in Excel? Or how do I split a string in excel? Also learn how to split a delimited string?   This is the formula featured in my video.   Split Raw Data into Columns  =TEXTSPLIT(A2,",",";")   Is there a text split function in Excel?,What is the shortcut key for split string in Excel?,How do I split a string in Excel without delimiter?,How do you split a string by multiple spaces in Excel?,How do you split a delimited string?,   Check out my complete suite of Microsoft Excel Tips and Tricks.  https://www.youtube.com/@RabiGurungXybernetics/shorts  https://www.tiktok.com/@xybernetics247  https://www.instagram.com/rabi.gurung247/  https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/  https://twitter.com/XyberneticsInc/media  https://www.reddit.com/r/Excel247/  https://www.facebook.com/XyberneticsInc/reels/   #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00If you have to split this raw data, which is a long string, into a column of salesperson

00:05and sales, and if you look at the raw data here, the salesperson column is actually delimited

00:10or separated using a colon, and the row is actually delimited using a semicolon.

00:17So you're going to have to use a function called tagSplit.

00:21First argument will be the location of where your raw data is, which is A2.

00:25Second argument, which is your column delimiter, which is going to be semicolon for us, and

00:29comma, and the row delimiter, or the next row, is going to be semicolon, like this, in double

00:36quote, of course, and close parenthesis, and hit enter, and it will split the raw data nicely

00:41into two columns here.

00:42And now, one thing to take away from this is that the function tagSplit is only available

00:47on Microsoft 365.

Is there a text split function in Excel? - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended