How do you split comma separated values - Excel Tips and Tricks

Learn how to split, separated values.

To split numbers separated by commas in Excel, you can use the "Text to Columns" feature. This feature allows you to split comma-separated values into separate columns easily. To do this, select the cells with the data, go to the "Data" tab, and click "Text to Columns." Choose "Delimited" and then select the comma as the delimiter to separate the numbers into columns. If you want to split comma-separated values into rows instead, you can use a combination of functions like TEXTSPLIT, TRANSPOSE, and TEXTJOIN to convert the data. For instance, using =TRANSPOSE(TEXTSPLIT(TEXTJOIN(", ", TRUE, A1:A10), ", ")) can help achieve this. This method works well for splitting values in Excel and converting comma-separated values to rows and columns using a comma delimiter.

How to split numbers separated by comma in Excel?
How do you split comma separated values?
How do you separate numbers with commas?
Split comma separated values in excel to rows and columns, comma delimiter, convert comma separated

Here, the formulas features in my video.

=TRANSPOSE(TEXTSPLIT(TEXTJOIN(", ", TRUE, B3:B22),","))

=XLOOKUP("*"&TRIM(E3)&"*",$B$3:$B$22,$C$3:$C$22,,2)

#shorts #short #shortvideo #fyp #excel #microsoft #tiktok #fypシ

[cvdung]

Thanks, it's a great trick with wildcards & xlookup

[alexbarbucristi]

that is not cringe at all. is something it can be done in less than 1 minute