Find and Replace
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.
|