I receive a text file which I convert some columns to text and others to
general. Then I save the file with a €œ.xls€� extension.

One column that is saved as text has a character code 31 item then some
additional digits.
Example: 123456-A

I want to delete the special character and leave the rest. Using €œfind and
replace€� does not find the special character even when I type the code
char(31) in the find box. I notice in a completely new worksheet find and
replace will find these special characters, but I can't get the same result
using this converted text file.

Is this doable using find and replace?

Thank You.