Text to Column to remove spacing between the string

Hi Community,

I had went through some of the previous discussion and noted that my wanted result a bit different with them. Kindly refer to the screenshot below for your reference.The screenshot below are after i input the txt file and all the words and numbers become one sentence with spacing in between the words

Criteria:

1.May i know how can i make to split into column between the spacing ?

Question

1. After we spilt it into column , some important information are not in the same column anymore, may i know how can we adjust from there? Can anyone share the workflow on this solutions？

Thank you

Common Use Cases

Accepted answers

phottovy

@SH_94Do you have "All whitespace" selected in the data cleansing too? If so, uncheck that option. The duplicate whitespace option should leave one space but the all whitespace will remove all spaces. Take a look at the attached example to see how I set up the data cleansing tool.

Remove Spacing.yxmd

All comments

phottovy

Hi @SH_94

Have you tried using the "Data Cleansing" tool using the "Tabs, Line Breaks, and Duplicate Whitespace" option? This will remove the extra spaces in your data. Then you can use the "Text to Columns" tool and split your data on spaces. Hopefully this will keep everything in the correct columns.

SH_94

Hi @phottovy ,

Yes, but the result will remove the spacing in between the words and show the result as below which is not the one that l looking for.

Original Data: AA BB

A CC

Result : AABB

ACC

But i want to split into words or number into respective column

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703