1. B

    Add superscript to a char in a cell with a formula

    Hi, everybody. Probably there is an easy solution, or maybe there no solution as well, to this problem. The scenario is simple: I have a cell (well, many others with the same issue, but this doesn't matter) in a sheet with a formula that create a text in different ways dependoing on other cells...
  2. N

    Macro with .subscript = FALSE doesn't change the text format

    Hi there, pretty new to macros and VBA, but I'm fairly confident this is strange behaviour. I wrote a little macro to toggle the last letter of the selected cell to superscript, to help make m^2 easier to format. I've pasted it below and it works perfectly. Only thing is, I went to do the same...
  3. J

    Superscript in Chart

    Hello, I have created a chart, in Excel 2016 and some of the data labels need to have a superscript. I have tried creating the superscript in the excel file behind the chart, and it does not translate to the chart. I have also tried to select the one character that needs to be superscripted in...
  4. J

    Custom If function to return an "Equation" or "Text Box"

    Hi all, I have a particular problem that I need help with. I have a spreadsheet with numerous equations that have been either typed into a cell or created using "insert-->equation". A lot of these equations have many subscripts and superscripts. My problem is that I want a cell to return a...
  5. C

    Superscript left and right parenthesis -- help is appreciated. Thanks!

    I know the superscript is =char(185), but I'd like there to be "(" and ")" in the superscript as well...I pulled the below codes from online: <thead> Encodings </thead><tbody> HTML Entity (decimal) ⁽ HTML Entity (hex) ⁽ How to type in Microsoft Windows Alt +207D UTF-8 (hex) 0xE2 0x81...
  6. E

    Retaining superscript format using VLOOKUP

    Hello! I am trying to transfer a number with superscript text after it (i.e. 1st with 'st' in superscript) from one worksheet to another using VLOOKUP. I haven't had any success in retaining the formatting. Any suggestions? Thank you!
  7. B

    Macro to look for a pattern and replace with subscript (H2O --> Hsub2O)

    I do a lot of spreadsheets where I type certainl chemical formulas over and over (CO2, H2O, CH4, N2O). When I finalize the report I am having to go into each instance and manually subscripting the number which takes forever. I am aware of a way to use autocorrect where I can type in something...
  8. netonet

    concatinating with superscript characters

    Hi, I want to know how to concatenate two strings. One cell (A1) having (x+y)2 = x2+y2+2xy here 2 comes in four places, in which first 3 places 2 is superscript. Another cell (B1) having : This is first formula. Third cell (C1) should be in correct answer, but it shows no superscripts.
  9. A

    Currency format and superscript numbers (VBA)

    I have a table that looks like this: A $125,000 B $350,000 C $109,000 D $122,000 The values come from formulas on another sheet and change frequently. The table gets attached to a publisher document that goes out to clients and row D has an important disclosure. Because of...
  10. Jaafar Tribak

    Subscript and Superscript characters on userform labels

    Hi, I never noticed that sub/superscript characters couldn't be displayed on userform captions until this was raised on this forum the other day. here is a little hack that i've managed to put together to simulate sub/superscrips via subclassing the userform.I am hoping this could be...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back