Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to remove HTML tags from Excel Sheet

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-01-2012
Member
 
Join Date: Jan 2012
Posts: 64
How to remove HTML tags from Excel Sheet

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, numeric 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 within this, whilst leaving the rest of the worksheet unaffected? Many thanks if you can help solve this little problem

Reply With Quote
  #2  
Old 25-01-2012
Member
 
Join Date: Jul 2011
Posts: 431
Re: How to remove HTML tags from Excel Sheet

I assume the text is in a normal cell or do you mean a text box. I tried a little test with find and replace and find <*> and in the replace box leave blank /replace all.
Reply With Quote
  #3  
Old 25-01-2012
Member
 
Join Date: Jan 2012
Posts: 64
Re: How to remove HTML tags from Excel Sheet

Unfortunately your suggested solution didnt work. The problem is that the text contained in the EXCEL cell (I have tried with both General and with text format) can contain up to 1500 - 2000 characters distributed into several hundred words. The overall EXCEL .xls file is about 10 MB size, and contains about 3000 rows with up to 17 columns. After trying your replace <*> trick just on the column gives me an error message saying 'Formula is too long'. Importing the whole .xls file into ACCESS, and trying the same replace operation on the column in question also gives an ACCESS error: 'There isn't enough free memory to continue the search.
Reply With Quote
  #4  
Old 25-01-2012
Member
 
Join Date: Aug 2011
Posts: 560
Re: How to remove HTML tags from Excel Sheet

Just tried it in this way. First copy your values then Mark the spot where you want to add them and then Edit > Paste 4th Values option. Another note, also used more often because: hyperlinks from the text go to the other column:
Code:
Function GetAddress (hyperlink cell As Range) 
GetAddress = Replace _ 
(HyperlinkCell.Hyperlinks (1) Address, "mailto:". '") 
End Function
Alt + F11 and Insert> Module and paste code. Alt + Q and save. The feature is found under "Custom" in the dialog box (Shift + F3). GetAddress = (A1) Where cell A1 for example has a hyperlink.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to remove HTML tags from Excel Sheet"
Thread Thread Starter Forum Replies Last Post
How to use Mail Merge from one Excel Sheet to another Excel Sheet Abélard MS Office Support 2 23-02-2012 01:59 PM
How to remove or sort the data order in Excel sheet Ramanujan MS Office Support 2 15-02-2012 07:12 PM
Unable to remove smart tags from Excel GurdeepS Windows Software 4 25-02-2010 08:13 AM
html tags in windows b.venu Operating Systems 1 17-09-2009 12:28 PM
About Hidden tags in HTML OmiWalia Software Development 3 06-08-2009 10:45 PM


All times are GMT +5.5. The time now is 04:43 PM.