Jul 24 2023 10:29 PM - edited Jul 25 2023 09:11 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. If there is a better way, I much appreciate the help
Jul 25 2023 12:34 AM
Not with formula. If only with Office Script, but I'm not sure.
Jul 25 2023 10:28 PM
Jul 26 2023 01:24 AM
Office Script is available on desktop for 365 business and educational subscribers, not sure on which channels. It shall be Automate tab on ribbon.
However, I'm not sure if it's possible to change format for the part of the text within the cell with ExcelScript package.
Jul 26 2023 07:45 PM
Jul 27 2023 04:17 AM
Nope, ExcelScript package is the same for everyone.