importing info from text file with multiple heading through document to excel

hi all, i'm new to the forum
i receive a text file which has multiple text/numeric headings throughout the document and info in text and numeric
i want to import the info into excel 2003 displaying the info in rows and columns but retain the numerous headings

i can open the text file in excel using fixed width but this action disects the header into multiple cells which is not suitable. i've spent many challenging hours trying different methods but have to admit failure

i want the header to be exported in column A and the info in rows and columns under each header.
the document sometimes has 80 headings

i've attached the text file and would appreciate any help

basicially i want the header in column A and under it in column A no, column B form, column C horse, column D wodds and so on

regards
neale

Hi FDibbins
thanks for your prompt response
unfortunately when using the space as a delimiter, the data seems to be in columns in the example but when you examine the spreadsheet the info is not in the correct columns
ie column A has the race time and under it the column for no but no numbers, this pushes all info across other columns, the worst example is a horse with 2 names the first name is in the woods column and the second name goes in the next column but a horse with only one name the price is in the same column as the second name of the other horse
but thanks for your response, i've tried the delimiter and fixed width but i think it requires visual basic code to
find the race heading, cut and paste it to column A in a spreadsheet
then count down 6 rows and cut and paste the info in column A (no is in column A) and the other info in columns to the right
i'd need this to be repeated to accommodate up to 1500 rows
damm complicated for me

Hi Norie
Thanks for your prompt response
i've done that a couple of days so far but its extremely time consuming and open to retyping errors as the header is split over so many columns
i have to do this every day, so i'd really like to automate it
i think visual basic code might be the answer
ie write code to cut and paste the header in column A on a spreadsheet
then count down 6 rows and cut and paste the info in columns from column A (no to be column A) and the other info in columns to the right
regards

hi norie
i can't import the file into excel without delimiting as the text import wizard automaticially starts when opening opening xl, file, open, the text file

can you suggest how i could open it and what code to use to split each row
thanks

hi norrie
i opened the file in xl and removed all the column brakes as you suggested
all the text file info is now visable but obviously not in columns
how do i get the info into the correctcolumns now?

hi janisjohan29
what info are you providing to me
i don't understand what you say "ind some good information that is so creative and use full method and I hope next we found a good information."

I Read your forum and find some use full information./

hi janisjohan29
yes the forum is excellent and does provide much useful info
hopefully with the gracious help of people like norie and others i'll have a solution to my problem

Thanks for replay me............ One of the time such as 3 years ago I was use Exxcel 2003. But now I use Excel 7.. Its comfortable and easy to use I think .. Can you tell me Excel new version condition what.....

hi norie
could you advise me the code you mentioned to split the info into columns or any other method as i have imported the info from the text file, fixed width and rem,oved the column breaks
and i can't work out what to do now
thanks