Forum Discussion
LOOKUP to include formatting with its Return Value? Formatting Code Function? non-VBA request
It'd be complicated. Could you provide an example of what you want to do?
I need to superscript an output of Excel formula to differentiate from other outputs of other formulae in same cell. Is there a non-VBA solution?
I need help to superscript first 3rd and subscript 4th argument
=TEXTJOIN("",TRUE,Acronymn[@[🛧]:[:bed:️]])
USE CASE
Example of above use is I am delegate for expense claiming for my Executive who is always on the road and has disorganized receipts (for good reason). I need to claim expense only once a month by company policy. To deal with missing receipts, I mobile texting my Executive because he/she has too many emails. Unfortunately, summary (not yet unconfigurable for filter) from Enterprise level Expense App is large Spreadsheet on a mobile screen and contains too many details; My workaround is reduction to a single line of text of items for mobile texting; because delineating items cost footprint in a string, I do away with delineator characters by applying subsequent word alternatively with Superscript and Subscript.
Since there is not yet Excel functionality, I wish Lookup can. As demo by screenshot, long text message (red) becomes much shorter (green) and use less mobile display footprint.
If there is a better way, I much appreciate the help
. Until my Enterprise Expense App cater to mobile messaging interim information such as comments, I wait for more end-user to voice how they mobile text a summary in spreadsheet format. Is there more effective way?
I fear that what you want is impossible. Excel does not support formatting part of the result of a formula.
If a cell contains a formula, formatting always applies to the entire cell.
So you'd have to replace the formula with its result, then convert individual characters to superscript. But that would require VBA. Also the formula would be lost, so changes in the source data would not be reflected in the cells that used to contain a formula.
