Text to columns macro (fixed width) w/ predefined format on result

[dusit_t]

Hi,

I am searching for fixed width-text to column macro and found a reply in the forum. However, when I apply the macro, the result of zeros in front of figures disappear since the format of value in splitted column doesn't predefined as text

e.g. sample text to split to column:
000122042009ABCDEFG00567

Required result:
0001|22042009|ABCDEFG|00567


when running below macro; result shows:
1|22042009|ABCDEFG|567
(Beginning zeros figures of the first and last column disappear)


Applied Macro:

Please Login or Register  to view this content.

Would anyone please help modify the macro to define result in some columns as text format?

Note: I can only apply "ready to use" macro (Excel 2003) but not keen on writing one... pls kindly help!

Many thanks
DT.

[JBeaucaire]

Hi dusit, welcome to the forum.

First, you'll need to go back to that first post, EDIT, GO ADVANCED (if necessary), highlight all the macro code and click on the # icon to wrap the code in [ code ] tags. It's highly valued forum rule / requirement.

Then, your post will be simple to read like this corrected macro code I offer here to resolve your issue:

Please Login or Register  to view this content.

[dusit_t]

Hi JBeaucaire,

Thank you so much for both informing the rule & offering help on the macro.
I have already edited the first post & definitely do it right next time!

DT.

[dusit_t]

posting in error