NEED HELP PLEASE

[manilla_r22]

HOW DO I GET THE * TO CHANGE TO (a) in superscript.
Need the parentheses as well.

I tried the replace button, it replaces the whole word as well.

I have multiple large files and trying to find the most efficient method

For example, i want it to look like this

 

[Akbarov]

Sub find_and_replace()

Dim find_value, replace_value As String

find_value = InputBox("Which Product You Want to Replace?")
replace_value = InputBox("Please Enter the New Value")

    Columns("C").replace What:=find_value, _
                            Replacement:=replace_value, _
                            LookAt:=xlPart, _
                            SearchOrder:=xlByRows, _
                            MatchCase:=False, _
                            SearchFormat:=False, _
                            ReplaceFormat:=False

MsgBox "Done With Replacement!"

End Sub

Try this code.

 

[manilla_r22]

I hope i did it right! i got this tho!

thank you!

 

[Akbarov]

At the end add:
End Sub

 

[manilla_r22]

Nothing happens,
press alt+f8
press run
pop up message of * then a pop up message of a
then it says complete, but no changes

 

[manilla_r22]

 

[manilla_r22]

View attachment 76179

Like this

 

[Akbarov]

Are you sure the words are in column C?
If not, replace ("C") with column you want to make replacement.

 Columns("C").replace What:=find_value, _

 

[manilla_r22]

Are you sure the words are in column C?
If not, replace ("C") with column you want to make replacement.

 Columns("C").replace What:=find_value, _

Just doubled check, all in column C

 

[Akbarov]

It will be better if you share sample file.