Notepad to Excel

[Flycaster]

Hello


I have a prn file with clearly defined columns.


The problem is that some of the rows contain field data.


Ideally I woudl like to specify what are the fields and then create an Excel file with columns for the fields and rows for the records.


Without actually seeing the file it is difficult to understand what I mean.


However, I'm sure one of you kind knowledgeable Excel aware people could look at the file and tell me exactly what to do.


If anyone would be kind to send me their email, I'll send the file.


Thanks for your help.


Kind regards


Alex

 

[Hui]

Alex

can you Randomise and Anonymize the data and put it on a free file sharing site?

Then post the link

 

[oldchippy]

Here's one


http://rapidshare.com/