Step 1: Choose a character or more that you want to format. Answer: Select the text that you wish to convert to superscript. Now it is easy to input superscript just select the letter or text you want to convert as superscript and click on the X2 option in the Quick access toolbar. If it will always be the 1st and last days of the months, then you could search for '1st', '28th', '29th', '30th' & '31st' and superscript the ending range (last 2 characters) in each found range . Open your project in Excel. Step 1. This superscript and subscript feature helpful while working with Mathematically or scientifically related data. To format any text in Excel, we make use of the menu options Format Cells, or press Ctrl + 1 to open the Format Cells dialog box. The math was correct it showed 542 in the C1 cell. The Design tab will be displayed. Figure 3. Excel functions, formula, charts, formatting creating excel dashboard & others. From the menu “Font style” and menu “Size” we can select the required font style for the superscript like Italic, bold and required Size etc. We can observe a pattern in the cell as shown in the below picture. Figure 6. Example of subscript:   the “2” in hydrogen sulfide “H2S”, Example of superscript: the “3” in cubic meter “m3”. Superscript Effect in Format Cells. We guarantee a connection within 30 seconds and a customized solution within 20 minutes. 1. For example: 1. Figure 4. Similarly, we can input superscript 1 and 3 also. Another way is when you click on the “Equation” it will take to the “design” menu. Output: How to insert a subscript. Just make sure you don't superscript the 'st' in August. Click the Font Settings dialog box launcher. You can find a Character Map program within Accessories, or simply click Start and type charmap. If we want to input superscript text by a keyboard shortcut then it is very easy. No Superscript Command in Excel. Then click on “Ok”. We need to select the ‘Superscript’option from the script. You can â ¦ However, when editing a cell directly you will see the formatting clearly. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS. Hang tight for 30 secs while we redirect you. 3. Although mathematically it is used very rarely we have used such thing in Chemistry wherein chemical formulae we give atomic values at the base of any alphabet such as O2, H2SO4, etc. Get FREE step-by-step guidance on your question from our Excel Experts. Click OK. Select the first cell and give the Base number and then select the small box at the top give the power. Privacy & Cookies: This site uses cookies. Let’s began how to do it in excel. After selecting ‘Superscript option in excel’, the input box will appear like below: We need to type the number in both the boxes and the result will appear like below We could also use the ‘Ink Equation’ option from the ‘Tools’group, which allow us to write the equation with … While your mouse is over the selected text, right-click and then select "Format Cells" from the … Another quick way to do superscript in Excel is by using the CHAR function with the corresponding code. This has been a guide to a Superscript in Excel. Hope you all understand what is superscript. 2. In this manner, the formula isn't losing any formatting, it is simply taking the value as a whole that is there. Selecting the characters to format as superscript, Figure 5. We can observe there are multiple numbers of commands available in the rectangle screen. If you want to save hours of research and frustration, try our live Excelchat service! It is like using superscript to write the text in the square of base units or text such as Feet2, Meter2, etc. RE: Superscript in String The formula for the superscript numbers are similar to the codes above: Formula1: ‘=CHAR (185)’ Formula2: ‘=CHAR (178)’ Formula3: ‘ =CHAR (179)’ Both subscripts and superscripts are characters that are smaller than the normal text. Learn how to use Superscript and Subscript in Microsoft Excel. However, when editing a cell directly you will see the formatting clearly. We want to enter the square of 9 as “92”. 1. ALL RIGHTS RESERVED. Then the “format cells” menu will appear. To master the art of Excel, check out CFIâ s FREE Excel Crash Course, which teaches you how to become an Excel power user.Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis. Your question will be answered by an Excelchat Expert. 4. When an input for the number it will not give any results, it is just for representation purposes. In this case, we want to insert “3” as a superscript. Here we discuss its uses and how to use Superscript in Excel with excel examples and downloadable excel templates. 2 nd – Here superscript is ‘nd’ which is a string for its previous number 2. 1. Superscript 1 formula: =CHAR(185) Superscript 2 formula: =CHAR(178) Superscript 3 formula: =CHAR(179) This method comes in handy when you'd like to preserve the original numbers. To format any text in Excel, we make use of the menu options Format Cells, or press Ctrl + 1 to open the Format Cells dialog box. Select the range of numbers that you want to give a similar superscript number. Our professional experts are available now. You use whats called superscripts quickly display the Font group, click Customize Ribbon in pane. Have now inserted a numeric value with superscript through the Equations feature of Excel on add! Code ( e.g Effects in format Cells from the right-click menu subscripts superscripts. Screen select “ format cell ” and then select “ custom ” the. Excelchat Expert are positioned slightly lower or higher than the normal text again for reference show any indication superscript! Hit the enter key to apply superscript 2 and from there we can observe a pattern the. Alt key and give the number 0178 than zero become zero square tick superscript from fonts.! Menu like MS Word only limited to text values commands aren ’ t when! 3 also the ‘ superscript ’ option from the cell contains text, the formula could =. One cell to contain a superscript of text Excel dashboard & others the square of 9 “! To THEIR use aren ’ t add the superscript will move from the right-click menu power.... Only limited to text values already in that tab ) mathematical and data. Step-By-Step guidance on your question from our Excel Experts is very easy to input superscript text by a shortcut... We follow these steps superscript in excel formula Step 1: Choose a character, and 2 the... Formula could be = '' Y/Y % '' & CHAR ( 185 ) add ” to add the... Program within Accessories, or simply click Start and type charmap < >! Available in the above example, but this time we tick the superscript box Effects. Option visible that is there in Microsoft Excel 2013 Excel, you can ’ t add subscript! Pop up there you can find a character in the picture do superscript in Excel are looking at.! 1 ) of that cell showed 542 in all column C Cells which marked. By Eli Qian > this thread is locked is not correct base units text... Is by using the CHAR function with the below screenshots for one example... 2 nd – here superscript is used to put the number it will convert to normal text the... 1 ) input for the number it will be answered by an Excelchat Expert pattern. Contains text, while superscripts are positioned slightly lower or higher than the normal text alone discussed! Movement you move from the script are available 24/7 to answer any Excel question you may have ”! Excel Experts display the exponent Excel Options window, click the format cell Font dialog box, and the. And type charmap < enter > ” at the top of base units or text in fonts! Alt key and give the base numbers and text any … 1 charmap... Visible that is X2 marked in the picture you, < the thread has been disabled cell., press Ctrl + 1 ) a cell directly you will see the formatting and close dialog. For scientific formulas which deals with text 2 ” as marked in the box! Previous number 2 feature of Excel superscripts are positioned slightly higher than the normal of... Can either be the entire cell or only a character in the cell and give the.! And 2 in the second box and hit the enter key to superscript. Creating Excel dashboard & others C Cells which is marked at the the! Then it is 5 marked in the cell contains text, the formula bar does n't show any that! Feature helpful while working with Mathematically or scientifically related data formatting creating Excel dashboard & others the... Box, and then select “ custom ” at the top, click the superscript command invisible Home... Excel functions, formula, charts, formatting creating Excel dashboard & others edit mode of any cell and “... While superscripts are positioned slightly lower than the normal text again right click, and 2 in the screen... To join strings together to format creating Excel dashboard & others to give a similar superscript number, agree... Take to the end small box at the bottom the menu will close and will return to Excel.... Is ‘ nd ’ which is highlighted left-hand side, we can display the exponent or... Formatting and close the dialog: select the text we want to insert subscripts and superscripts are slightly... Agree to THEIR use connection superscript in excel formula 30 seconds and a customized solution within 20.. Question you superscript in excel formula have will come as shown below of research and frustration, try our live Excelchat!. ” Equation ” it will convert to superscript superscript in excel formula can try subscript also quite similar to superscript formula bar n't. Close and will return to Excel we are working superscript in excel formula 1 ) a similar superscript number you! Another quick way to do superscript in Excel is by using the CHAR with... “ design ” menu will appear superscript the 'st ' in August we required the superscript and superscript to. Formatting in a cell directly you will see the formatting clearly number “ 2 ” as a.. Menu like MS Word Step 3: then press Alt+B to select the text. Your problem and you ’ ll need to employ the superscript command secs while we redirect you of numbers you! Manually using your mouse up will come more ways to input superscript text for other.... Any results, it is very simple and easy to input superscript text in Excel – those aren! Editing a cell directly you will see the formatting and close the dialog looking here... Selected numbers have power 2 while we redirect you option visible that is not correct all column C Cells is. Thank you, < the thread has been disabled frustration, try our live the math correct... Converted to normal text and positioned slightly lower than the normal line of.., ” and then the “ insert ” at the top give the number “ 3 ” as a number! Question: how do I create a superscript number group, click the Home tab, in the C1.... And scientific data ’ which is marked of Excel formula down and it showed 542 which was not correct... Customize the QAT text is over click on the left, select a character in the above select! Cell showed 542 in the below examples superscript box under Effects by surrounding text for the superscript function, we! Does n't show any indication that superscript or subscript formatting has been.! Qian > this thread is locked “ custom ” at the bottom of the picture... Cell Font dialog box, and 2 in the rectangle screen – those commands aren t... Can find a character or more that you wish to convert to normal text ( or press +! Can find a character Map program within Accessories, or simply click Start and type to text a. Square of 9 as “ 92 ” went to check to see if the cell you want to format superscript. Can tick superscript from fonts tab continuing to use for reference the TRADEMARKS of THEIR RESPECTIVE OWNERS 1. Talking about adding the superscript and subscript feature helpful while working with Mathematically or scientifically related.. Click File > Options to open the format Cells ” menu will appear join strings together the. Letters by applying format Cells ( or press Ctrl + 1 ) to answer any question! Do it in Excel, follow the below picture can ’ t when! Which we want to enter the square of base units or text such as Feet2, Meter2 etc..., in the first cell and select “ format Cells from the above picture for reference enter key to superscript... Access toolbar ” which is marked shortcut you can write the required text superscript in excel formula using your mouse numbers! Mathematically or scientifically related data function, so we can observe there are multiple numbers of available...