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
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.
Hello lopezio,
Have you tried?:
RegardsPlease Login or Register to view this content.
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] .
Hello lopezio,
OR?:
RegardsPlease Login or Register to view this content.
Maybe:
* The space after the first Replace has to be removedPlease Login or Register to view this content.
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
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
Thank you Kyle123
Solved with the following code:
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks