Search : in
By :

Can Excel functions Return Formatted Text to

Explorer, on Feb 1, 2009 10:05:43 pm GMT 
 Report this message to moderators

Hello,

I have a spreadsheet function that returns a multi-line text string to a single cell with wrapping using some lookup functions on another sheet. I wish to bold some of these lines of text but not others. My problem is how to do this inside the function using the ".Characters(start,length).Font.Bold = True" when the function returns the text to be displayed as an unformatted text string.

Any help would greatly be appreciated, thank you.

Regards

Explorer.

Configuration: Windows XP
Firefox 3.0.5

Best answers for « Can Excel functions Return Formatted Text to » in :
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
[Excel 2003] - IF Function using Dates & Text Show[Excel 2003] - IF Function using Dates & Text Issue Solution Note Issue I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but...
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Download Grab Text ShowDescription The application is designed by GrabText.com. So far it has won many awards from some places and it is also well known worldwide, even being used in companies. Grab Text is a tool that is based on text recognition. The application allows...
Spreadsheets - Mathematical Functions ShowStandard Functions Function Description ABS() This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative ODD(value) Rounds a number up to the...