Forum Discussion
johnwedeles
Helper III
Helper IIIReplacing text in column with new text based on condition
Hello: I am trying to replace a hyphen ("-") with an en dash in an existing column. I know I'd need to use UNICHAR for this. So, I imagine the formula would be something like this: IF Table N...
if it is a value in a cell, use substitute
Column = SUBSTITUTE('Table'[Column1],"-",UNICHAR(8211))if it is the name of a measure, you replace the whole measure name
ryan_mayu
Super User
Super Userif it is a value in a cell, use substitute
Column = SUBSTITUTE('Table'[Column1],"-",UNICHAR(8211))if it is the name of a measure, you replace the whole measure name
johnwedelesHelper III
Helper IIIThank you, ryan_mayu !