how to strip html

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

Is there a way to strip the html in an entire column?

I do it using regular expressions in access but not sure how to do it here.

I guess if I knoew how to put code behind events as a user enters data into
a cell, that would be a start.


Thanks again
 
Hi Danny,
To strip the HTML tags you can should be able to do that in Excel with
Regular Expressions as well. I haven't really done replacements yet,
but since you have, you'd be way ahead in the game. See my page
http://www.mvps.org/dmcritchie/excel/excel.htm

Extraction of a Group of Digits and Dashes, from postings by Harlan Grove
http://www.mvps.org/dmcritchie/excel/grove_digitsid.htm

If not familiar with installing and using subroutines in Excel see
http://www.mvps.org/dmcritchie/excel/getstarted.htm.htm
 
Thanks

I look forward to learning this

Danny

David McRitchie said:
Hi Danny,
To strip the HTML tags you can should be able to do that in Excel with
Regular Expressions as well. I haven't really done replacements yet,
but since you have, you'd be way ahead in the game. See my page
http://www.mvps.org/dmcritchie/excel/excel.htm

Extraction of a Group of Digits and Dashes, from postings by Harlan Grove
http://www.mvps.org/dmcritchie/excel/grove_digitsid.htm

If not familiar with installing and using subroutines in Excel see
http://www.mvps.org/dmcritchie/excel/getstarted.htm.htm
Click to expand...
 
Back
Top