Forum Discussion
LOOKUP to include formatting with its Return Value? Formatting Code Function? non-VBA request
Afraid not. Formulae in Excel work with values, not with properties which are applied by formatting.
- Thanks, Is there VBA already done for such?
It'd be complicated. Could you provide an example of what you want to do?
- Thanks for prompt response, instead of duplicating my info, there is later details in my reply to Hans Vogelaar Jul 26 2023 07:55 PM.
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?
Perhaps HansVogelaar could clarify about VBA, that's not my territory.
