LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
glennwhite
 
Posts: n/a
Default Remove html markup tags in an EXCEL cell?


I have a worksheet containing text extracted from a web page that still
includes html markup tags, or example <BR, <font etc and all the other
normal html markup codes. This is stored inside an EXCEL text cell. The
rest of the Worksheet contains normal text, numberic and date data.
Does anyone please know a way to automatically strip out all of the
html markup tags from the single column that I have with these in,
whilst leaving the rest of the worksheet unaffected? Many thanks if you
can help solve this knotty little problem


--
glennwhite
------------------------------------------------------------------------
glennwhite's Profile: http://www.excelforum.com/member.php...o&userid=35085
View this thread: http://www.excelforum.com/showthread...hreadid=548373

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Changing Cell Reference's when Pasting in Excel No I'm Spartacus Excel Discussion (Misc queries) 0 February 13th 06 01:01 PM
How do I display html code within a cell? John-Raritan Excel Discussion (Misc queries) 6 October 31st 05 03:59 PM
Pasting Word table cell with paragraph markers into single Excel c Steve Excel Discussion (Misc queries) 1 June 16th 05 11:26 PM
Allow Excel to retain HTML hypertex done from another editor. Valente Excel Discussion (Misc queries) 0 May 22nd 05 03:31 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"