How to superscript part of the formula in cell

[AGolinsky]

Hi!

I have different formulae that return or "+3 %" or "-3 б.п." (cylillic letters) or "46 rub for $", and in all that cases i need to have whatever comes after numbers to appear superscripted.

I found this to be not a trivial task at all. Not sure it is solvable without VBA, but it is seems vba wont help neither. Another idea was to create custom font, but, using windows special characters, it seems a downing task..

Please advice. Any idea how to to solve it?

Many thanks in advance!

[6StringJazzer]

If a formula returns the entire text that you are showing, it can't be done. The result of a formula must have only one text format applied.

There might be a way to create a custom format, if the units are the same. It's difficult to give details without more information about what you are doing.

[AGolinsky]

Thank you for your response. The designers designed a ppt slide, with a lot number on it. These numbers has to be sourced from excel. So i am trying to replicate number formatting in excel.

Снимок.PNG

[MrShorty]

It's not hard to do with a text literal, but cannot be done on the result of a formula. If the authors of the ppt used Excel, I'm guessing they had a cell with the formula that generated the text string, then copy -> paste as value into another cell -> edit the cell (F2) -> select the desired characters -> format as superscript.

[6StringJazzer]

One way to do this is to separate the formula to put the number in one cell and the units in another cell.

superscripts.JPG

[AGolinsky]

Thanks a lot, guys! Both suggested solutions will work like a charm. Thanks again!

[6StringJazzer]

You're welcome and thanks for the rep!