How to Add Subscript and Superscript with a Formula in Excel 1. Using CHAR Function Selectcell C5and enter this formula to add superscripts usingthe CHAR function: ="2"&CHAR(185) Note: TheCHARfunction can only return3superscripts and no subscripts. 2. Using UNICHAR Function Selectcell C5and ...
In Excel, we can quickly replace a specific value with another one by applying Find and Replace function, but have you ever suffer with a problem that to find a specific character in specific text string and the replace it as superscript format, such as find YL3 and then replace with YL3...
Caveat: Unlike the previous method,Excel custom number formatdoes not change the original value in a cell, it only changes thevisual representationof the value. In the above screenshot, you can see 1³ in cell A2, but the formula bar displays 1, meaning the actual value in the cell is...
Learn how to apply superscript and subscript formats in Excel using various methods, including formulas, custom formatting, and keyboard shortcuts.
Excel Easy #1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us Superscript and Subscript in Excel It's easy to format a character as superscript (slightly above the baseline) or subscript (slightly below the baseline) in Excel. 1. For example...
To create superscript in Microsoft Excel, follow these steps.Click the cell containing the text you want to make superscript. In the formula bar, highlight the character you want to set as superscript.Press Ctrl+1 to open the Format Cells window. Click the checkbox for the Superscript option...
Speaking of formulas, Excel has tons and tons of built-in formulas to help you work faster and smarter Learn what a formula is and how to write one when yousign up for my free online email course. Plus, you’ll learn about the most basic functions in Excel such as the SUM, AVERAGE,...
We can use the following formula in cellE6to apply superscripts here: =B6&CHAR(D6) After pressingEnterand dragging down theFill Handleicon, we will get the following output: The1,2&3superscripts display properly, but we have a#VALUE!Error for the other characters. We can resolve this probl...
Subscript Format in ExcelSubscript format usage is quite rare in Excel. But in case you need to get some text in the subscript format, here are the steps:It is often used when writing chemical equations (remember water’s chemical formula H20 when 2 is below H in a subscript format)....
Select characters in a cell or cell range that you’d like to format. On theHometab, in theFontgroup, select the Font Settingsdialog box launcher. OR Press CTRL+1. UnderEffects, check theSuperscriptorSubscriptbox, and clickOK. Tip:Although Excel doesn’t have quick keyboard sh...