Hello,
I'm trying to use Convert Text to Columns function, but in a formula format, rather than using the option in the bar. The reason is that I want just to paste the raw data from the .csv file and have the data automatically converted from text into separated columns. And I can't use VBA or anything like that.
I'm using Google sheets, so I've tried to use a simple formula on B1 like this: =split(A1,",",false,TRUE) and on B2 like this: =split(A1,",",false,false), and kind of works but its also bringing the associated quotation marks, which I can't have.
Example of content on cell A2: XPTO AB.,"2021-01-17","0","0","","","1.00","0","0","0","0","0","3"
And the split formula returns B1: XPTO AB C2: "2021-01-17" D2: "0" / and so on...so on...
I've also tried with Trim and other commands that I've found on other similar posts, but I don't get it working properly.
If formula Masters can give me help here, I would be much appreciated.
The request was also posted here.
I'm trying to use Convert Text to Columns function, but in a formula format, rather than using the option in the bar. The reason is that I want just to paste the raw data from the .csv file and have the data automatically converted from text into separated columns. And I can't use VBA or anything like that.
I'm using Google sheets, so I've tried to use a simple formula on B1 like this: =split(A1,",",false,TRUE) and on B2 like this: =split(A1,",",false,false), and kind of works but its also bringing the associated quotation marks, which I can't have.
Example of content on cell A2: XPTO AB.,"2021-01-17","0","0","","","1.00","0","0","0","0","0","3"
And the split formula returns B1: XPTO AB C2: "2021-01-17" D2: "0" / and so on...so on...
I've also tried with Trim and other commands that I've found on other similar posts, but I don't get it working properly.
If formula Masters can give me help here, I would be much appreciated.
The request was also posted here.