Hi Ron

Thanks for your help so far. Much appreciated. Just hope someone has already
done this like you said. Fingers crossed.

Thanks again

Regards

Stuart

"Ron Coderre" wrote:

Yikes! I just checked the file.
Each of those cells has many thousands of characters.....evidently, too many
for Find/Replace to handle.

I'm going to hope that somebody has already programmed a solution, because
so far, I haven't come up with any tricks that have worked.

***********
Regards,
Ron


"Stuart" wrote:

www.underonelink.com/help.xls

"Stuart" wrote:

All 2500 products are on one sheet, if you want an example i can give you an
example but it will take up alot off room in here and can out it on the
server as a download so you can see what Im talking about

Regards
Stuart

"Ron Coderre" wrote:

OK...more information is good....but...

How about:
Q: Are all 2500 products in one sheet?
If yes, you don't have to Edit/Replace one at a time; you can click the
[Replace all] button. Did you do that?

Q: Are they all in one workbook?
If yes, group the sheets together (Select the first sheet, hold down the
[Shift] key, then select the last sheet). Then, do the same Edit/Replace as
above.

Q: Multiple workbooks?
How many workbooks? If only a few, then use the above technique on each.
If many...well...let's see if we need to cross that bridge.

Does that help?

***********
Regards,
Ron


"Stuart" wrote:

Thanks for the quick reply.

I have over 2500 products to do so that would take some finding and
replacing. Is there no formula or script that I can use to do this
automatically.

Regards

Stuart

"Ron Coderre" wrote:

I think this will get you most of the way the
EditReplace:
Find What: <*
Replace with: (this should be blank)
Click the [Replace] button until you're sure it's doing what you want. Then,
click the [Replace All] button.

That will leave some extraneous spaces, so do another Find/Replace for
double spaces and, again, replace them with nothing.

Does that help?

***********
Regards,
Ron


"Stuart" wrote:

How do I remove HTML markup from and cell.

i.e.
<DIV class=productdesc <H3SCALLYWAGS CHANGING MAT. </H3<TABLE border=0
<TBODY <TR <TD <UL <LIFoam-filled <LIWipe-clean surface <LIFits most
dressers <LIdimensions: 75 x 46cm </LI</UL</TD</TR
<TR</TR</TBODY</TABLE <UL <LIWhen using a changing mat on a dresser or
other raised surface, never leave your baby unattended even for a moment
</LI</UL</P</DIV

I want it to read:-

SCALLYWAGS CHANGING MAT. Foam-filled Wipe-clean surface Fits most dressers
dimensions: 75 x 46cm When using a changing mat on a dresser or other
raised surface, never leave your baby unattended even for a moment

I am trying to change out website csv file into a froogle csv file but
without the HTML

Thanks in advance

Stuart