View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Remove html markup

Thanks for letting us know. I'm glad you finally got something you could
work with.

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


"Stuart" wrote:

That works fine, I also added

EditReplace
Find what: \{*\}
Replace with: (enter 1 space)
Click the [More] button to see search options and select: Use Wildcards
Click the [Replace All] button




"Ron Coderre" wrote:

Hi, Stuart

See if this works for you....

Copy the list of HTML cells from Excel to MS Word.

In MS Word:
EditReplace
Find what: \<*\
Replace with: (leave this blank)
Click the [More] button to see search options and select: Use Wildcards
Click the [Replace All] button

Then...EditReplace
Find what: (enter 2 spaces)
Click the [Replace All] button
-That will eliminate strings of spaces

Then...EditReplace
Find what: &nbsp
Replace with: (enter 1 space)
Click the [Replace All] button
-That will replace non-breaking space codes with 1 space

Finally:
Select the whole Word document
EditCopy
Select the first HTML cell in Excel
EditPaste

It might not be perfect, but is it close enough?


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


"Stuart" wrote:

Hi David.

Thanks for that, the only problem with that is it leaves lots of blank cells
when pasted back into excel. I've even tried saving the spreadsheet as csv
and text file to see if that would help when pasted back into excel. No luck
there.

Any more ideas greatly accepted.

Regards

Stuar

"David McRitchie" wrote:

Hi Stuart,
I would go to Steve Miller's http://www.stevemiller.net/apps/
and install Pure Text then you can copy the HTML from an HTML page
click on the PT system taskbar button, and paste into notepad.

If you start from the Excel sheet, copy from the column, Paste into notepad,
save as HTML (junk.htm) from notepad, open the junk.htm file with your
browser, copy the everything on the sheet (Ctrl+A, Ctrl+C) then paste
into notepad and you will have your text. After you have installed and
used Pure Text the process should take about 3 minutes to convert in that
manner.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
.