Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Replace value with new value containing a superscript

Hello, In Power Query how can I replace a value with a new value containing a superscript.  I need to replace oldName with  newName+  where the + is a superscript. Thanks,
Need Help
  • PwerQueryKees's avatar
    PwerQueryKees
    1 year ago

    Before:

     

    After

    With the formula:

    = Table.ReplaceValue(#"Changed Type","+", Character.FromNumber(0x207A),Replacer.ReplaceText,{"Value"})

     

    Did I answer your question? Then please mark my post as the solution and make it easier to find for others having a similar problem.
    If I helped you, please click on the Thumbs Up to give Kudos.

     

    Kees Stolker

    A big fan of Power Query and Excel

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks.  Your solution does work.  Staying with your example, assume the starting value is "Anything" rather then "Anything+".  How would you replace "Anything" with "Anything+" (+ is a superscript)?

PwerQueryKees's avatar
PwerQueryKees
Super User
1 year ago
Table.ReplaceValue(#"Changed Type","Anything+", "Anything" & Character.FromNumber(0x207A),Replacer.ReplaceText,{"Value"})