Forum Discussion
jracer007
Helper IV
Helper IVReplace Text with other text
Hello community,
I want to request your help to replace the text of a Custom Column with the text of other column.
Original Text:
Desired text:
Thank and happy year!!
14 Replies
- Greg_Deckler
Community Champion
Looks like you are in query editor. Why not just remove your custom column, duplicate your desired column and rename the new column to your deleted column name?
jracer007because the original column is created by LOOKUPVALUE from another column of more fields
v-chuncz-msftCommunity Support
You may try Power Query M function Text.Replace and Text.ReplaceRange, and DAX Function REPLACE Function and SUBSTITUTE Function.
- jracer007
Could you help me with the formula please? I am new at this.
- v-chuncz-msft
