How to make ONLY the word 'Approved' a superscript (and NOT the number) with both values in the same

[James Perry]

A single cell is formatted to include the word 'Approved' (wherever applicable) + a budget value.
Both values are in a single cell. Approved on the left and the budget value on the right.
I only need to make the word 'Approved' display as a superscript.
My question....
Is there a way to do the same in Excel....???
Thank you.

 

[Somendra Misra]

Hi James,

Try below code id sheet module where you are trying this:

Private Sub Worksheet_Change(ByVal Target As Range)

Application.ScreenUpdating = False
Application.EnableEvents = False

If Not Intersect(Target, Range("D2:D10")) Is Nothing Then  ' Change the range to your range.
    With Target.Characters(Start:=1, Length:=8).Font
        .Superscript = True
    End With
   
    With Target.Characters(Start:=9, Length:=6).Font
       
        .Superscript = False
    End With
   
Application.ScreenUpdating = True
Application.EnableEvents = True
End If
End Sub

Regards,

 

[Khalid NGO]

Hi James,
Is that you were looking for?
Press F2 > Select Text


Press Ctrl+1:


Enable Check Subscript



Regards,

 

[Khalid NGO]

Oh its superscript.
Mistakenly mentioned subscript

Edit:
Will not work if you manage the word "approved" with custom formatting.

 

[James Perry]

Thanks, Khalid. That's really cool.

 

[Khalid NGO]

Thanks, Khalid. That's really cool.

Welcome James,
Thanks for the feedback.