Empty Rectangle Text to Columns

[pebbles789]

I have a data sheet where the text is separated with the empty rectangle character and would like to replace it with semicolon to complete a text to columns. First, I used the ctrl+h function, but was not able to copy the character in the Find What field. I also tried pasting the character into the custom text to columns delimiter with no success. Next, I tried recording the VBA code from a successful Find/Replace and modifying the Find What parameter with the character. Running the code replaced all my text with a semicolon.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Using a front end tool or VB, how do I replace the rectangle character on a worksheet or take the existing characters and use them as the text to columns delimiter? <o></o>

 

[jimrward]

here is one approach in a spare cell try and grab the code as follows

=CODE(mid(a1,4,1) if the [] symbol is at the 4th character, this will reveal the ASCII code of the bogey character

you can then use the result in a SUBSTITUTE function, as follows

=SUBSTITUTE(A1,CHAR(whatevercodefoundabove),";")

 

[pebbles789]

This worked perfectly! Thanks for the help!