Which actually is better than Excel. Currently I have to work with Excel. Gosh, how bad it got. Especially CSV import and cell formating. They really worked on being incompatible to even basic data formats just to keep you in their eco system. Try to import a UTF-8 CSV where the delimiter and the number format differs from the system settings. It completely fucks up your data and you have to import it as text and then you have to format each colum separately. Because changing the format from text to number does NOT change the view. You have to update each column manually. FU MS.
There are comedy videos about number formatting in Excel:
https://youtu.be/yb2zkxHDfUE?si=CtYMI-5FsU2bPZUF
Thanks for trying to help. But that’s the point. They make something which was easy deliberately overly complicated. The next step will be that they force you to discuss the csv import with ChatGPT for 5 minutes.
And every time you’ll hear: well ok, this step now is more complicated, but we gave you a mighty tool which can do SO much more.
Which actually is better than Excel. Currently I have to work with Excel. Gosh, how bad it got. Especially CSV import and cell formating. They really worked on being incompatible to even basic data formats just to keep you in their eco system. Try to import a UTF-8 CSV where the delimiter and the number format differs from the system settings. It completely fucks up your data and you have to import it as text and then you have to format each colum separately. Because changing the format from text to number does NOT change the view. You have to update each column manually. FU MS. There are comedy videos about number formatting in Excel: https://youtu.be/yb2zkxHDfUE?si=CtYMI-5FsU2bPZUF
Power Query might solve your problem. You can do a text to columns with as many custom delimiters as you want.
Thanks for trying to help. But that’s the point. They make something which was easy deliberately overly complicated. The next step will be that they force you to discuss the csv import with ChatGPT for 5 minutes. And every time you’ll hear: well ok, this step now is more complicated, but we gave you a mighty tool which can do SO much more.