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 Userwhy this is a measure? not a value in a cell? How did you calculate this? you can just paste your sample data here or paste a screenshot
johnwedelesHelper III
Helper III- ryan_mayu
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
- johnwedeles
Thank you, ryan_mayu !