Organise data

**micko_escalade** · 03-23-2007, 11:15 PM

Hi all!

I need to clean out unnecessary data from a file,
(see attached text file),
I'm not sure how to go about this in excel,

basically every file starts with 9 cells that needs to be deleted,
two cells of real data then one with garbage that needs to be deleted, it goes like that for 40 cells,
then again 10 cells of garbage that needs to be deleted, then
40 of real data and goes like that up to 3000 lines,

I know it sounds confusing but if you take a look at attached file it will make more sense,

at the end I need to have
all cells full of data,

any help is appreciated!

**davesexcel** · 03-24-2007, 01:06 AM

Originally Posted by micko_escalade

Hi all!

I need to clean out unnecessary data from a file,
(see attached text file),
I'm not sure how to go about this in excel,

basically every file starts with 9 cells that needs to be deleted,
two cells of real data then one with garbage that needs to be deleted, it goes like that for 40 cells,
then again 10 cells of garbage that needs to be deleted, then
40 of real data and goes like that up to 3000 lines,

I know it sounds confusing but if you take a look at attached file it will make more sense,

at the end I need to have
all cells full of data,

any help is appreciated!

hi,
you could zip your xl file and then we would be able to work with it....

**micko_escalade** · 03-24-2007, 02:06 AM

Thanks for the reply!

attached is the excel file,
it should look like this Link

**micko_escalade** · 03-24-2007, 02:22 AM

Just wanted to mention that this is cross-post from MrExcel
I thought internet is big, but I guess not

**Bryan Hessey** · 03-24-2007, 03:36 AM

Originally Posted by micko_escalade

Thanks for the reply!

attached is the excel file,
it should look like this Link

Hi,

one way, in column B the formula

=IF(AND(ISNUMBER(A1),LEN(A1)=9),"y","")

and then autofilter, select Blanks, and delete all blank rows.

Is this an occasional or one-off, or something required often?

---