+ Reply to Thread
Results 1 to 7 of 7

Show cell as html

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2003
    Posts
    30

    Show cell as html

    Hi
    Any ideia how can I show one cell with html content as html?
    Instead of


    <b> Hello</b> World
    the result will be

    Hello World

    Thank you
    Last edited by AliGW; 12-26-2018 at 06:26 PM. Reason: Thread correctly marked as solved.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Show cell as html

    Hello lopezio,

    Have you tried?:

    Please Login or Register  to view this content.
    Regards
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: Show cell as html

    Hello lopezio,

    OR?:

    Please Login or Register  to view this content.
    Regards

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Show cell as html

    Maybe:

    Please Login or Register  to view this content.
    * The space after the first Replace has to be removed
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,210

    Re: Show cell as html

    I don’t think any of the above are actually what you’re after as a generic solution. My immediate response was to copy the cell and use the paste as html option - there are some examples here https://stackoverflow.com/questions/...-an-excel-cell - note I’d leave the top answer alone and scroll down to the other options, using ie is likely to be very slow in comparison

  6. #6
    Registered User
    Join Date
    10-18-2012
    Location
    Portugal
    MS-Off Ver
    Excel 2003
    Posts
    30

    Re: Show cell as html

    Thank you Kyle123
    Solved with the following code:

    Please Login or Register  to view this content.

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,100

    Re: [Solved] Show cell as html

    Hello lopezio,

    You never mentioned that this would apply to Range A1 only. The Code you have posted as a solution, works, once only, as far as the Bold text of the Specified word/s is/are specified. As soon as you select another Cell Range A1 changes All the Text to regular Font, which contradicts your initial requirement.

+ 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. Calculate VAT off Selling Price and Show in HTML Email
    By somerset-uk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2018, 12:07 PM
  2. VBA to Import HTML Table Locally Stored HTML file to excel
    By ermengard in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-09-2015, 10:48 AM
  3. Excel ws into outlook html body with current html signature
    By Cadelanne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 09:03 AM
  4. 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
  5. Show the title information from HTML tables
    By glg in forum Excel General
    Replies: 0
    Last Post: 02-25-2010, 05:56 PM
  6. How to add HTML header/footer to export as HTML?
    By JGCA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2009, 04:29 PM
  7. Comment indicators show as numbers in HTML
    By Bob Sweet in forum Excel General
    Replies: 0
    Last Post: 01-18-2006, 12:00 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