How to remove?

[rmartinez4]

Hi,

I want to remove this square from this column. I do have other data formatted this way in this column (DFRSSETD123, 192.000.121.1, etc) but I can't seem to remove this character.

[binuacs]

@rmartinez4 try the TrimLeft(String,y) function where you need to specify the character you wanted to remove in place of y 

[rmartinez4]

Odd. The squared in front does not show up as a character.

[Robin_McIntosh · Accepted solution]

Try a REGEX tool like this.

[rmartinez4]

You're Magical 

[Robin_McIntosh]

@rmartinez4 Also removes the pesky black diamond with question mark if you ever get them.