ace_cool_an
New Member
- Joined
- Nov 22, 2005
- Messages
- 1
Hi,
I have a file with the following format
FHEADxxyyzz
THEADabcdefgh
TDETLafaaffffff
TTAILsdfsdfdff
THEADasdfdf
TDETLasdas
TTAILasffd
FTAILsffdfdf
I want to format this in such a way that,
a) first I want all FHEADs on one page, all Theads on another n so on.
b) Then I want to covert them using "text to column" providing the field lengths etc.
How can I write a macro for this? Even the first part wud help. Just separate them out into separate sheets
regds,
A
I have a file with the following format
FHEADxxyyzz
THEADabcdefgh
TDETLafaaffffff
TTAILsdfsdfdff
THEADasdfdf
TDETLasdas
TTAILasffd
FTAILsffdfdf
I want to format this in such a way that,
a) first I want all FHEADs on one page, all Theads on another n so on.
b) Then I want to covert them using "text to column" providing the field lengths etc.
How can I write a macro for this? Even the first part wud help. Just separate them out into separate sheets
regds,
A