Split CSV-data into columns.
Optionally, choose delimiter, string if blank and columns to return.
Setup is similar to TEXTJOIN.
Now, it can be all done on the worksheet.
Copy and paste to another worksheet to keep using the function!
Receiving data with non numerical characters blocking Excel from doing calculations?
With KEEP, you can define to keep only 0123456789 and thus purge all others. You chose the characters to keep or purge.
Here's a calculated way to do it.