Excel wizards in here please

[mattyj1085]

I have an excel sheet where each row has web page information in.

From Cell C3 and I am trying to remove the following from the start

<div style="padding-right: 0px; padding-left: 0px; float: left; padding-bottom: 0px; margin: 0px; width: 600px; padding-top: 0px; height: 300px; background-color: #f3f3f3">
<div style="padding-right: 10px; padding-left: 10px; padding-bottom: 10px; padding-top: 10px">

and

</div>
</div>

From the end

This then needs to be copied down around 300 rows to remove the div information from each page.

I have tried find and replace but it says the formula is too long and a few other ways

Does anyone know a way of removing the Div information and copying this down the sheet? (otherwise i will need to edit 300 pages individually)


Thanks

 

[mattyj1085]

How do i export the data from the excel file to individual an individual text document (or documents?

When i try and save it as unicode text is says "the document is not completely saved" or do i save as another format then open that using notepad ++?

 

[mattyj1085]

its a huge database export i think (not done by me) I can open the XLS file in notepad ++ and remove and div information, but as soon as you make any changes and save then try and open it in excel it either doesnt work or messes the date in the file up.

What i need to do is keep all the data in rows exactly the same so it can be reimported back to the database. So far this involves me going through it by hand or editing each webpage (using a built in editor) individually

These are the columns

PageID AreaID HTML Text Security PageName

The HTML is what i am trying to remove (but without moving any other data (or inserting any other junk)

Thanks anyway

 

[mattyj1085]

thanks all. neally done now, had me and 2 other developers removing the info from pages. The div info (character length) was different on some pages anyway tomsk, but thanks anyway