ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Use format tags in a Cell (https://www.excelbanter.com/excel-discussion-misc-queries/221449-use-format-tags-cell.html)

Allen

Use format tags in a Cell
 
Hi,
Is there a way in Excell 2007 to use the format html tags to format the
text? I am pulling data off of a SQL server and the Text for a discriptiong
is rich text so it has all the format when entered by a user in a web base
form. This is stored in SQL and now I am creating a report (pivot table) in
Excel and the formating tags are shown in the cell. I would like to display
the text in Excel formatted.

Shane Devenshire[_2_]

Use format tags in a Cell
 
Hi,

there is nothing built into Excel to automatically apply web formatting tags
to a cell. You might be able to write custom functions to do it.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Allen" wrote:

Hi,
Is there a way in Excell 2007 to use the format html tags to format the
text? I am pulling data off of a SQL server and the Text for a discriptiong
is rich text so it has all the format when entered by a user in a web base
form. This is stored in SQL and now I am creating a report (pivot table) in
Excel and the formating tags are shown in the cell. I would like to display
the text in Excel formatted.



All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com