1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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!
  6. 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...
  7. 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.
  8. 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...
  9. 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...

Some videos you may like

This Week's Hot Topics