How to put the code in a for loop or simplifing the code

[willy292]

Hi all,

I dont want to paste eight time of the below code, is there any way to simplify the code
Thanks a lot for all your attention

For each column which is (D:K)

DO

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code next time as per forum rules.

[Andy Pope]

You need to explain more about what you are trying to do. Probably posting a workbook containing before and after data layout would help.

If you have data in columnd D:K then surely the first TextToColumns for column D would overwrite some if not all the columns to the right?

[willy292]

I got a table exporting from access and I would like to formating the info from D column to K column as text, so I use TextToColumns

[Andy Pope]

Can you post example file

Are you saying the content of column D does not contain any TABS

[willy292]

As attached is the file I export from the access database, I want to do some statistic base on the D column to K column, but before doing that, I have to turn these column into string and that's why I need to use column-to-text to manipulate the data first

[Andy Pope]

I don't know whether your example is the output or input.

Please Login or Register  to view this content.