Forum Discussion
PQ: How to split a large column into 50 characters columns but split only at whitespace?
I have a large table (>80'000 rows) with a column (max width = 163) that I need to resize into smaller columns. The rules are: - split only at whitespaces - column size max 50 characters - 2 colu...
To resize a large table column in Microsoft Excel: Use the Text to Columns feature. Choose "Delimited" and select "Whitespace" as the delimiter. Set column widths to a maximum of 50 characters. For the third column, specify a width greater than 100 characters. This will efficiently split the specified column based on whitespace and meet the defined size criteria. [link removed by admin]
Thanks, but I am looking into a PowerQuery (PQ) solution . I appologize for not writing this the right way...