Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - FormatHTML function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - FormatHTML

Syntax:
=FormatHTML(Cell)

Description:
Formats the cell contents as HTML code. When the cell content is italic or bold the result of this function will display the <i> and <b> tags. Cell formatting of parts of the cell text is also supported, e.g. when a single word is made italic and the remainder is normal text.

Cell : the address of an Excel cell (e.g. A1)

Example:

Display the text in A1 in HTML code
=FormatHTML(A1)

litLIB