Is there a function to superscript part of a cell formula to differentiate its output among others?

Brass Contributor

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 helpdemo for mobile texting how to do away with delineators in long stringdemo for mobile texting how to do away with delineators in long string

5 Replies

@sunnyschindler 

Not with formula. If only with Office Script, but I'm not sure.

Thanks for responding. Would you know if Office Script is for Desktop yet? As for Excel Online or Excel Web, it still doesn't feature Subscript and Superscript.
Is there production level VBA for Font Subscript and Superscript on word if not character?

@sunnyschindler 

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.

My version does not have "change format for the part of the text within the cell with ExcelScript package". Is there beta version that can?
Probably, it will be available when enough demand come in. 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?

@sunnyschindler 

Nope, ExcelScript package is the same for everyone.