+ Reply to Thread
Results 1 to 3 of 3

Delete everything except HTML tags

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    Rome, Italy
    MS-Off Ver
    Excel for Mac
    Posts
    11

    Delete everything except HTML tags

    Hello all!
    I'm trying to find a code to delete from a column everything except HTML tags.
    So, I simply need to remove all text, except what's between "<" and ">".

    If a cell contains this text:
    This is <br>only a <b>sample</b>

    I'd like to get this:
    <br><b></b>

    Could anyone please help me?

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Delete everything except HTML tags

    Hi
    this macro should create a string from the code in the selected cells and put that string in the cell to the right of the one with the code:

    Please Login or Register  to view this content.
    it could be tweaked into a user-defined formula, if you like
    Last edited by NickyC; 05-26-2015 at 09:57 PM.

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    Rome, Italy
    MS-Off Ver
    Excel for Mac
    Posts
    11

    Re: Delete everything except HTML tags

    Thanks a lot, NickyC!

    It works like a charm

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using HTML tags in Excel VBA
    By Excel Guy 123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2014, 12:44 PM
  2. [SOLVED] How to pull HTML tags in certain grouping?
    By DuncR6 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-20-2012, 12:36 PM
  3. convert formated excel column to html source text with html tags
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2011, 04:22 PM
  4. Delete HTML tags
    By sglick in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-31-2007, 04:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1