Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to quickly find and replace character with superscript in Excel?

doc find replace superscript 1
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 as below screenshot shown. Of course, you can find and replace them one by one, but this method cost too much time. If there are any tricks can quickly replace with superscript in Excel? Follow this article, you will get the answer.

Find and replace with superscript by Find and Replace function

Find and replace with superscript by VBA

Subscript numbers in Chemical Formulas (subscript all numbers after each element in chemical formulas.)

doc subscript numbers in chemical formulas 1doc subscript chemical numbers

arrow blue right bubble Find and replace with superscript by Find and Replace function


Actually, you can use Find and Replace to find the text and then replace with superscript format.

1. Select the range you want to find and replace work for, and press Ctrl + H to open the Find and Replace dialog.

2. In the Find and Replace dialog, click Replace tab, and then enter the text you want to find into the Find what textbox. See screenshot:
doc find replace superscript 2

3. Then go to Replace with textbox, enter the text you want to replace with, take notice, hold Alt key and then press 0179 keys on the Number board to enter the superscript number 3. See screenshot:
doc find replace superscript 3

4. Click Replace All. And a dialog pops out to remind you how many replacements have been done. See screenshot:
doc find replace superscript 4

Tip: But with this method, you only can superscript number 2 by pressing 0178, and 3 by 0179.


arrow blue right bubble Find and replace with superscript by VBA

With Find and Replace function, only can replace the number with superscript. If you want to replace letter with superscript as below screenshot shown, you can apply VBA code to solve it.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

1. Press Alt + F11 keys to open Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste below VBA code to the script.

VBA: Find and replace with superscript format

Sub DoConvert()
'UpdatebyExtendoffice20160705
    Dim xRg As Range
    Dim xTxt As String
    Dim xCell As Range
    On Error Resume Next
    If ActiveWindow.RangeSelection.Count > 1 Then
      xTxt = ActiveWindow.RangeSelection.AddressLocal
    Else
      xTxt = ActiveSheet.UsedRange.AddressLocal
    End If
    Set xRg = Application.InputBox("Select a range:", "Kutools for Excel", xTxt, , , , , 8)
    If xRg Is Nothing Then Exit Sub
    For Each xCell In xRg
        If xCell.Value = "YL3" Then
            xCell.Characters(1, 1).Font.Superscript = True
        End If
    Next
End Sub

doc find replace superscript 5

3. Press F5 key to run the code, and a dialog pops out to remind you select a range. See screenshot:
doc find replace superscript 6

doc attention 1  Kutools for Excel's Auto Text, collect all formulas to a group as auto text, you can insert them anytime as you want whithout remembering! Free Download Now!

4. Click OK, the specific character in specific string has been converted to be superscript format in the selection. See screenshot:
doc find replace superscript 7

Tip: in the code, “YL3” is the string you want to find from, and (1, 1) indicates to convert first 1 character of the string, if you want to convert first two character, you can change it as (1, 2), if you want to convert 1 character from second character of the string, you can change it as (2, 1).

doc download 1



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.