Replacing text with special character - check marks

[johnwedeles]

Hello:

I have created a table visual. The underlying Excel table contains check marks, which were not retained when I imported the table. Now that I've imported the table, I'm trying to change the existing text in several columns (specifically, a "Y") to a check mark. 

Based on preliminary research, I may be able to use the UNICHAR function to replace the "Y" with a check mark, but haven't gotten it to work. Would appreciate any guidance.

Thank you!

[Greg_Deckler · Accepted solution]

Or:

Column = IF([Column1]="Y",UNICHAR(10003),[Column1])

[Greg_Deckler · Accepted solution]

Or:

Column = IF([Column1]="Y",UNICHAR(10003),[Column1])

[johnwedeles]

That worked! Thank you very much! @Greg_Deckler 

[Greg_Deckler]

Glad to hear it!

[johnwedeles]

Hello @Greg_Deckler - is it possible to add an additional (or nested) filter to this formula? For example, I want to say:

If column 1 contains "Y", then UNICHAR 10003

and (this would be the additional filter)

if column 1 contains "-", then UNICHAR 8211

Thank you!

[Greg_Deckler · Accepted solution]

@johnwedeles - Yes, you could use a nested IF statement or use a SWITCH(TRUE()...) statement.

[johnwedeles]

Thank you, @Greg_Deckler !

[Greg_Deckler]

Should be:

Column = UNICHAR(10003)